Storing of Value in a variable | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Storing of Value in a variable

Hi friends,
Can anybody put some details about how to store a value in variable Thanks in advance!
You mean in a stored procedure? if so, you have to declare the datatype of the variable
ans SELECT @var = value or SET @var = value.
If you need this inside a select statement, you would do it with a select statement Bambola