Question: what is difference between @ and @@ in sql server?
Answer: There is no difference. The rules for variables state that they start with an '@' character and follow the rules for identifiers. ... In previous versions of SQL Server @ described a local variable and @@ describe a global variable. Now (SQL 2008) @@ is used for a function name so @@ shouldnt be used as a parameter name.