7.multipleinserts.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 18 行

INSERT INTO CustomerDetails.Customers 
(CustomerTitleId,CustomerFirstName,CustomerOtherInitials,
CustomerLastName,AddressId,AccountNumber,AccountTypeId,
ClearedBalance,UnclearedBalance)
VALUES (3,'Bernie','I','McGee',314,65368765,1,6653.11,0.00)
GO
INSERT INTO CustomerDetails.Customers 
(CustomerTitleId,CustomerFirstName,CustomerOtherInitials,
CustomerLastName,AddressId,AccountNumber,AccountTypeId,
ClearedBalance,UnclearedBalance)
VALUES (2,'Julie','A','Dewson',2134,81625422,1,53.32,-12.21)
GO
INSERT INTO CustomerDetails.Customers 
(CustomerTitleId,CustomerFirstName,CustomerOtherInitials,
CustomerLastName,AddressId,AccountNumber,AccountTypeId,
ClearedBalance,UnclearedBalance)
VALUES (1,'Kirsty',NULL,'Hull',4312,96565334,1,1266.00,10.32)