Hi,

I am new in field of DBA...

I just want to know that can we assign value to a variable through SELECT statement also as done in the

question

Select @STR=1,

whts the difference between -

Set @STR=1

select @STR=1

in this quesion?