The difference between set @flag = 1 and set @@ flag = 1

Question

Hi what is the difference between

set @flag=1 and set @@flag = 1 in SQL Server?

thanks

Answer 1

Nothing. Some built-in functions have names starting with double with the @@ signs as a legend. To avoid confusion, it is often recommended to use names starting with @@ .

Source: MSDN: Using Identifiers — Rules for Regular Identifiers .