SQLServer2008新增TSQL简写语法计算机等级考试

文章作者 100test 发表时间 2010:01:01 08:26:23
来源 100Test.Com百考试题网

　　1.定义变量时可以直接赋值
　　DECLARE @Id int = 5
　　2.Insert 语句可以一次插入多行数据
　　INSERT INTO StateList VALUES(@Id, WA), (@Id 1, FL), (@Id 2, NY)
　　3.支持 =操作符
　　SET StateId = 1
　　完整示例如下：
　　view plaincopy to clipboardprint?CREATE TABLE StateList(StateId int, StateName char(2)) GO -- Declare variable and assign a value in a single statement DECLARE @Id int = 5 -- Insert multiple rows in a single statement with IDs 5, 6, and 7 INSERT INTO StateList VALUES(@Id, WA), (@Id 1, FL), (@Id 2, NY) -- Use compound assignment operator to increment ID values to 6, 7, and 8 UPDATE StateList SET StateId = 1 -- View the results SELECT * FROM StateList CREATE TABLE StateList(StateId int, StateName char(2))
　　GO
　　-- Declare variable and assign a value in a single statement
　　DECLARE @Id int = 5
　　-- Insert multiple rows in a single statement with IDs 5, 6, and 7
　　INSERT INTO StateList VALUES(@Id, WA), (@Id 1, FL), (@Id 2, NY)
　　-- Use compound assignment operator to increment ID values to 6, 7, and 8
　　UPDATE StateList
　　SET StateId = 1
　　-- View the results
　　SELECT * FROM StateList 结果集为：
　　StateId StateName
　　------- ---------
　　6 WA
　　7 FL
　　8 NY
　　(3 row(s) affected)