T-SQL 宣告與指定變數的用法

Posted on Edited on In Views: Disqus:

 

以下小小範例說明了如何宣告變數、變數初始化、設定值的用法

1
2
3
4
DECLARE @Name nvarchar(100), @Age int = 30
SET @Name = 'Bob'

select @Name as Name, @Age as Age
Name Age
Bob 30