使用set关键字
1 | declare @variable int |
使用select语法
1 | select @variable = <column or expression> from <tableName> |
申明的同时赋值
1 | declare @variable int = <value> |
value 可以直接赋值 ,也可以是表达式.
举例
1 | declare @t datetime = (select getdate()) |
1 | declare @variable int |
1 | select @variable = <column or expression> from <tableName> |
1 | declare @variable int = <value> |
value 可以直接赋值 ,也可以是表达式.
举例
1 | declare @t datetime = (select getdate()) |