SQL Server 练习实例_原创文档.pdf

--学习SQL完全手册bywhb

以下是准备工作

usemaster

go

--建立数据库

createdatabasesales

go

usesales

go

--建立订单表

createtableorders(

order_numintprimarykeynotnull,

custintnotnull,

order_datedatetimenotnull,

repintnotnull,

mfrvarchar(20)notnull,

productvarchar(30)notnull,

qtyintnotnull,

amountintnotnull)

select*fromorders

droptableorders

go

--在表中插入数据日期型的字段插入时必须用单引号引起来，不用的话会显示不正确的时间。

insertintoorders

values(112961,2117,2012-11-5,106,REI,2A44L,7,31500)

insertintoorders

values(113012,2111,2012-9-5,105,ACI,41003,35,3745)

insertintoordersvalues(112989,2101,2012-12-5,106,REI,114,6,1458)

insertintoordersvalues(113051,2118,2012-8-5,108,REI,XK47,4,1420)

insertintoorders

values(112968,2102,2012-11-7,101,ACI,41004,34,3978)

insertintoorders

values(113036,2107,2012-2-15,110,ACI,4100Z,9,22500)

insertintoorders

values(113045,2112,2011-11-21,108,ACI,2A%4R,10,45000)

insertintoorders

values(112963,2103,2011-12-3,105,ACI,41004,28,3276)

insertintoorders

values(113013,2118,2012-5-15,108,ACI,41003,1,652)

insertintoorders

values(113058,2108,2012-6-15,109,ACI,112,10,1480)

insertintoorders

values(112997,2124,2012-1-15,107,REI,41003,1,652)

insertintoordersvalues(112983,2103,2012-6-1,105,ACI,41004,6,702)

insertintoorders

values(113024,211