SQL Server Performance

Storing of Value in a variable

Discussion in 'T-SQL Performance Tuning for Developers' started by vvkp, Aug 20, 2003.

  1. vvkp New Member

    Hi friends,
    Can anybody put some details about how to store a value in variable Thanks in advance!
  2. bambola New Member

    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

Share This Page