انواع متغییرها در SQL Server 2005 :

[B@RBOD]

<!--[if !supportLists]-->1- <!--[endif]-->متغییرهای عمومی (Global)
<!--[if !supportLists]-->2- <!--[endif]-->متغییرهای محلی (Local)

<!--[if !supportLists]-->1- <!--[endif]-->متغییرهای عمومی : این نوع متغییرها توسط سیستم تعریف و نگهداری میشود ، لیستی از این متغییرها به نقل از MSDN در ذیل آورده شده است :

· <?XML:NAMESPACE PREFIX = V /><V:SHAPE id=_x0000_i1026 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@CPU_BUSY (Transact-SQL)
· <V:SHAPE id=_x0000_i1027 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@CURSOR_ROWS (Transact-SQL)
· <V:SHAPE id=_x0000_i1028 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@DATEFIRST (Transact-SQL)
· <V:SHAPE id=_x0000_i1029 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@DBTS (Transact-SQL)
· <V:SHAPE id=_x0000_i1030 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@ERROR (Transact-SQL)
· <V:SHAPE id=_x0000_i1031 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@FETCH_STATUS (Transact-SQL)
· <V:SHAPE id=_x0000_i1032 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@IDENTITY (Transact-SQL)
· <V:SHAPE id=_x0000_i1033 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@IDLE (Transact-SQL)
· <V:SHAPE id=_x0000_i1034 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@IO_BUSY (Transact-SQL)
· <V:SHAPE id=_x0000_i1035 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@LANGID (Transact-SQL)
· <V:SHAPE id=_x0000_i1036 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@LANGUAGE (Transact-SQL)
· <V:SHAPE id=_x0000_i1037 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@LOCK_TIMEOUT (Transact-SQL)
· <V:SHAPE id=_x0000_i1038 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@MAX_CONNECTIONS (Transact-SQL)
· <V:SHAPE id=_x0000_i1039 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@MAX_PRECISION (Transact-SQL)
· <V:SHAPE id=_x0000_i1040 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@NESTLEVEL (Transact-SQL)
· <V:SHAPE id=_x0000_i1041 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]-->!--[endif]-->@@OPTIONS (Transact-SQL)
· <V:SHAPE id=_x0000_i1042 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@PACK_RECEIVED (Transact-SQL)
· <V:SHAPE id=_x0000_i1043 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@PACK_SENT (Transact-SQL)
· <V:SHAPE id=_x0000_i1044 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@PACKET_ERRORS (Transact-SQL)
· <V:SHAPE id=_x0000_i1045 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@PROCID (Transact-SQL)
· <V:SHAPE id=_x0000_i1046 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@REMSERVER (Transact-SQL)
· <V:SHAPE id=_x0000_i1047 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@ROWCOUNT (Transact-SQL)
· <V:SHAPE id=_x0000_i1048 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@SERVERNAME (Transact-SQL)
· <V:SHAPE id=_x0000_i1049 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@SERVICENAME (Transact-SQL)
· <V:SHAPE id=_x0000_i1050 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@SPID (Transact-SQL)
· <V:SHAPE id=_x0000_i1051 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TEXTSIZE (Transact-SQL)
· <V:SHAPE id=_x0000_i1052 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TIMETICKS (Transact-SQL)
· <V:SHAPE id=_x0000_i1053 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TOTAL_ERRORS (Transact-SQL)
· <V:SHAPE id=_x0000_i1054 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TOTAL_READ (Transact-SQL)
· <V:SHAPE id=_x0000_i1055 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TOTAL_WRITE (Transact-SQL)
· <V:SHAPE id=_x0000_i1056 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@TRANCOUNT (Transact-SQL)
· <V:SHAPE id=_x0000_i1057 style="WIDTH: 12pt; HEIGHT: 12pt" alt="" type="#_x0000_t75"><V:IMAGEDATA src="file:///D:\Users\Hosein\AppData\Local\Temp\msohtml1\01\cli p_image001.gif" o:href="http://i.msdn.microsoft.com/Platform/Controls/Toc/resources/e.gif"></V:IMAGEDATA></V:SHAPE><!--[if !vml]--><!--[endif]-->@@VERSION (Transact-SQL)

<!--[if !supportLists]-->2- <!--[endif]-->متغییرهای محلی (Local) این نوع متغییرها که توسط کاربر تعریف میشوند عموما برای ذخیره سازی داده های حاصل از محاسبات میانی بکار میروند ، جهت تعریف این نوع متغییر ها باید از دستور Declare استفاده کنیم و البته لازم به ذکر است که لیست محدود تری از این متغییر ها زمان ایجاد جداول نیز در دسترس هستند .
قوانین نامگذاری متغییر های زبان T-SQL مشابه قواعد نامگذاری دیگر زبانهای برنامه نویسی است با این تفاوت که ، نام متغییر الزاما باید با @ آغاز شود و بعد از آن یک حرف بزرگ یا کوچک یا یک عدد و بع از آن هر کاراکتر شامل حرف ، عدد یا زیر خط .