SQLServer 2008 新增T-SQL 简写语法

1.定义变量时可以直接赋值
declare @id int = 5
2.insert 语句可以一次插入多行数据
insert into statelist values(@id, 'wa'), (@id + 1, 'fl'), (@id + 2, 'ny')
3.支持+=操作符
set stateid += 1
完整示例如下：

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)