USE helloworld UPDATE saleManagerD.ContactDetail SET amount=2800, unitprice=2500 WHERE ContactID=56 GOSELECT * FROM saleManager.ContactDetail GO
下面是创建表时的代码: USE helloworld GO CREATE SCHEMA saleManagerD GO CREATE TABLE saleManagerD.ContactDetail( ContactID INT NOT NULL, ProducyID INT NOT NULL, ProductName VARCHAR(128), amount INT , unitprice NUMERIC (8, 2), otherInfo VARCHAR (128) ) GO INSERT INTO saleManager.ContactDetail VALUES(36,25,'露丝',2500,1800,'露丝露丝') INSERT INTO saleManager.ContactDetail VALUES(56,45,'萝莉',2400,2800,'萝莉萝莉') INSERT INTO saleManager.ContactDetail VALUES(55,44,'琳达',45400,11100,'琳达琳达') GO SELECT * FROM saleManager.ContactDetail GO
这看不出,Update sql语句在查询分析器能成功执行吗?
USE helloworld UPDATE [saleManagerD.ContactDetail] SET amount=2800, unitprice=2500 WHERE ContactID=56 GOSELECT * FROM [saleManager.ContactDetail] GO
楼主仔细看你的代码: USE helloworld UPDATE saleManagerD.ContactDetail --这里修改的数据表是saleManagerD.ContactDetail SET amount=2800, unitprice=2500 WHERE ContactID=56 GOSELECT * FROM saleManager.ContactDetail --这里查询的数据表是saleManager.ContactDetail GO完全是两个不相同的架构名啊,也就是修改的表和查询的表是完全不一样的两个表。
UPDATE saleManagerD.ContactDetail
SET amount=2800,
unitprice=2500
WHERE ContactID=56
GOSELECT *
FROM saleManager.ContactDetail
GO
USE helloworld
GO
CREATE SCHEMA saleManagerD
GO
CREATE TABLE saleManagerD.ContactDetail(
ContactID INT NOT NULL,
ProducyID INT NOT NULL,
ProductName VARCHAR(128),
amount INT ,
unitprice NUMERIC (8, 2),
otherInfo VARCHAR (128)
)
GO
INSERT INTO saleManager.ContactDetail
VALUES(36,25,'露丝',2500,1800,'露丝露丝')
INSERT INTO saleManager.ContactDetail
VALUES(56,45,'萝莉',2400,2800,'萝莉萝莉')
INSERT INTO saleManager.ContactDetail
VALUES(55,44,'琳达',45400,11100,'琳达琳达')
GO
SELECT *
FROM saleManager.ContactDetail
GO
UPDATE [saleManagerD.ContactDetail]
SET amount=2800,
unitprice=2500
WHERE ContactID=56
GOSELECT *
FROM [saleManager.ContactDetail]
GO
USE helloworld
UPDATE saleManagerD.ContactDetail --这里修改的数据表是saleManagerD.ContactDetail
SET amount=2800,
unitprice=2500
WHERE ContactID=56
GOSELECT *
FROM saleManager.ContactDetail --这里查询的数据表是saleManager.ContactDetail
GO完全是两个不相同的架构名啊,也就是修改的表和查询的表是完全不一样的两个表。