declaration of variables

[Ravi Shankar43]

iam getting error when setting the value to the variable.

[coolestCoder]

can you post what you have written along with the error message ?

---

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

---

coolestCoder

[Mairaaj Khan]

Ravi Shankar43 wrote:

iam getting error when setting the value to the variable

Hi, Suppose you have a varchar type variable, named @abc. With T-SQL you can assign value to @abc in two ways. 1- With the SET keyword

SET @abc='Its varchar typed'

2- With the SELECT keyword

SELECT @abc='Its new value'

However, with the SELECT keyword you can assingn values to multiple variables according to the following syntax. SELECT varialbe1 = value[, variable2 = value, ...]

________________________________ Success is not something to wait for, its something to work for.

[Ravi Shankar43]

ok i got the solution.i forgot to keep it in single quotes.