SQL Server variable scope in a stored procedure

by

From books online:

The scope of a variable is the range of Transact-SQL statements that can reference the variable. The scope of a variable lasts from the point it is declared until the end of the batch or stored procedure in which it is declared.

However. Nothing keeps you from doing this:

create procedure Foo as begin

declare @bob int

if exists (x)
begin
    set @bob = 1
end
else
begin
    set @bob = 2
end

end

More Related Contents:

  1. What is wrong with this DB Diagram? [closed]
  2. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  3. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  4. Efficiently convert rows to columns in sql server
  5. How can I do an UPDATE statement with JOIN in SQL Server?
  6. Not equal != operator on NULL
  7. Why does NULL = NULL evaluate to false in SQL server
  8. The multi-part identifier could not be bound
  9. How can I select the first day of a month in SQL?
  10. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  11. T-SQL – Insert Data into Parent and Child Tables
  12. Copy tables from one database to another in SQL Server
  13. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  14. Is it possible to specify condition in Count()?
  15. Fastest way to update 120 Million records
  16. how can I Update top 100 records in sql server
  17. How to find current transaction level?
  18. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  19. Pivot data in T-SQL
  20. How can I compare time in SQL Server?
  21. Drop all tables whose names begin with a certain string
  22. SQL: capitalize first letter only [duplicate]
  23. UPDATE and REPLACE part of a string
  24. Improve SQL Server query performance on large tables
  25. Suggestions for implementing audit tables in SQL Server?
  26. T-SQL Skip Take Stored Procedure
  27. How do I list all the columns in a table?
  28. Script entire database SQL-Server
  29. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
  30. Convert bigint to datetime

Leave a Comment