var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am having a simple question.
Select @test = 'test'
Set @test = 'test'
Can anyone give me the difference between the above
Effectively there is no difference. Either will assign the variable a value. Personally, I prefer to use SET whenever I'm just assigning one variable a value and use SELECT when I'm returning a resultset.
not a lot.
you can only set one variable with set but can set multiple ones with select and have to use a subquery to get a value from a table with set but I think set has less overhead.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors