createupdate.txt

来自「本人使用SQL SERVER 数据库3年」· 文本 代码 · 共 21 行

/* CreateUpdate.txt */

USE LumigentDemoDB

SETUSER

SETUSER 'CustomerService'

INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(1000,'Passy','Frederic','102 De Gaulle Way','Paris', '','','France')

UPDATE Customers Set Address = '16 Champs Elysse' WHERE CustID = 1000

UPDATE Customers Set Address = '44 Rue de Morgan' WHERE CustID = 1000

UPDATE Customers Set City = 'Jura' WHERE CustID = 1000

INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(1001,'Arnoldson','Klas Pontus','Halsingegatan','Stockholm', '','','Sweden')

SETUSER