how to declare global variable in SQL Server..?

by

There is no way to declare a global variable in Transact-SQL. However, if all you want your variables for is to be accessible across batches of a single script, you can use the SQLCMD tool or the SQLCMD mode of SSMS and define that tool/mode-specific variables like this:

:setvar myvar 10

and then use them like this:

$(myvar)

To use SSMS’s SQLCMD mode:

enter image description here

More Related Contents:

  1. How to create 500 columns programatically in SQL Server? [duplicate]
  2. SQL Server bulk insert for large data set
  3. T-SQL split string
  4. Solutions for INSERT OR UPDATE on SQL Server
  5. Conditional WHERE clause in SQL Server
  6. SQL NOT IN not working
  7. How to Join to first row
  8. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  9. GROUP BY to combine/concat a column [duplicate]
  10. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  11. Difference between CTE and SubQuery?
  12. How Can I use “Date” Datatype in sql server?
  13. Can a Check constraint relate to another table?
  14. Constraint for only one record marked as default
  15. How to send email from SQL Server?
  16. How to Replace Multiple Characters in SQL?
  17. How To Create Table with Identity Column
  18. T-SQL: Selecting Column Based on MAX(Other Column)
  19. SQL dot notation
  20. Split function in SQL Server 2008
  21. PIVOT query on Distinct records
  22. How to read the last row with SQL Server
  23. Performance of SQL Server 2005 Query
  24. OPENXML with xmlns:dt
  25. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  26. How to set bool value in SQL
  27. Finding node order in XML document in SQL Server
  28. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  29. How do I find the data directory for a SQL Server instance?
  30. How to update rows with a random date

Leave a Comment