jestges
Reputation: 3740
Difference between set @flag =1 and set @@flag = 1
What is the difference between
set @flag=1 and set @@flag = 1 in SQL Server?
Upvotes: 5
Views: 1004
Answers (1)
Daniel Vassallo
Reputation: 344481
Nothing. Some in-built functions have names that start with double at signs @@ as a convention. To avoid confusion it is often recommended that you do not use names that start with @@.
Source: MSDN: Using Identifiers - Rules for Regular Identifiers.
Upvotes: 7
Related Questions
- Difference between @@ and @ in SQL Server 2008 R2
- SQL - When to use @Variable
- What's the difference with or without the leading (@) for a command parameter in C#
- Set flag to database column
- Difference of Commands between SQL Server 2005 and 2008
- Differences between select @var=column1 from table1 & select top 1 column1 from table1
- Flag parameter doesn't work correctly (SQL)
- Who do @@OPTIONS and sp_configure provide different output?
- SQL Difference Between Parameter and value
- Difference between two stored Procedure