All Tags »
Transact SQL »
consistency (RSS)
Sorry, but there are no more tags available to filter with.
-
Be careful: unlike most other languages, T-SQL does not limit variables' scope to the block where the variable has been defined. For example, the following snippet compiles and runs:
-- @to is not in scope yet-- the line below would not compile--SET @to = @to + 3 ;IF DATEPART(weekday, GETDATE()) = 3 BEGIN ...
-
In the following script one out of six semicolons does not parse. Can you guess which one we need to remove without running it or scrolling down for the answer? Does it make sense to ...