您现在的位置是：网站首页> 编程资料编程资料
SQLServer 2008 新增T-SQL 简写语法_mssql2008_
2023-05-27
419人已围观
简介 SQLServer 2008 新增T-SQL 简写语法_mssql2008_
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)
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)
您可能感兴趣的文章:
相关内容
- SQLServer 2008 Merge语句的OUTPUT功能_mssql2008_
- SQL2008中 阻止保存要求重新创建表的更改 的解决方法_mssql2008_
- sqlserver2008 拆分字符串_mssql2008_
- SQL Server2008导出数据之Excel详细解析_mssql2008_
- mssql 监控磁盘空间告警实现方法_mssql2008_
- 使用SQL Server 2008远程链接时SQL数据库不成功的解决方法_mssql2008_
- SQL Server Native Client下载 SQL Server Native Client安装方法_mssql2008_
- 关于SQL Server 2008 安装提示"重新启动计算机失败"的解决办法_mssql2008_
- 安装SQL Server 2008时 总是不断要求重启电脑的解决办法_mssql2008_
- sql server 2008数据库无法启动的解决办法(图文教程)_mssql2008_
