SQL Server 2005基础教程一书的源代码.

源代码在线查看: 2.fixupcustomerdetails.customers.sql

软件大小: 62 K
上传用户: ASD___1234
关键词: Server 2005 SQL 基础教程
下载地址: 免注册下载 普通下载 VIP

相关代码

				DELETE FROM CustomerDetails.Customers
				DBCC CHECKIDENT('CustomerDetails.Customers',RESEED,1)
				INSERT INTO CustomerDetails.Customers 
				(CustomerTitleId,CustomerFirstName,CustomerOtherInitials,
				CustomerLastName,AddressId,AccountNumber,AccountTypeId,
				ClearedBalance,UnclearedBalance)
				VALUES (1,'Vic',NULL,'McGlynn',111,87612311,1,4311.22,213.11)
				INSERT INTO CustomerDetails.Customers 
				(CustomerTitleId,CustomerLastName,CustomerFirstName,
				CustomerOtherInitials,AddressId,AccountNumber,AccountTypeId,
				ClearedBalance,UnclearedBalance)
				VALUES (3,'Mason','Jack',NULL,145,53431993,1,437.97,-10.56)
							

相关资源