what is the use of @@,@,#.## key words in sql server?

Question

Dear all, i want to know what is the reson for using @ key word and @@ key word and # and ## key words in sql server. kindly explien any one brifly.. thanks and Regards Prasad Bhagat

Pankaj Kumar Choudhary · Answer

hello @prasad # key word is use for Local temp Table ## key word use for Global Temp table @ use for variable declaration or table variables Declare @My_vari TABLE ( IID int , Name Nvarchar ( 50 ), Salary Int , City_Name Nvarchar ( 50 ) ) @@ use for predefine function or methos loke @@ROWCOUNT .............

Prasad Bhagat · Answer

Dear pankaj , ur answer was perfect thankyou ... Thankx and Regards Prasad Bhagat

Suraj Sahoo · Answer

I am sorry Prasad, I am unaware of the # and ## in SQL server. Never came across this, can you give me an example where you have used this before? Thanks

Prasad Bhagat · Answer

Dear Suraj, Thanks for your quick reply can u tell me where can i use # and ## keywaords Thanks and Regards Prasad Bhagat

Suraj Sahoo · Answer

Hi Prasad, What I think is they are not the reserved keywords in the SQL Server. You can get the list of reserved keywords at:- https://msdn.microsoft.com/en-us/library/ms189822.aspx These are the syntactical expressions which differentiate normal letters from the SQL understandable keywords. Now for example, @@ROWCOUNT, if we write only ROWCOUNT we would get syntax error. Saying Invalid syntax near ROWCOUNT. Thus append @@ and it understands. Similarly are the other expressions you have mentioned. I hope this helps you some way. Accept if helps. Thanks

what is the use of @@,@,#.## key words in sql server?

Answers (5)