General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>>>No, SET it was my mistake (copy and paste).
>>>>Put SET before every variable.
>>>
>>>I see now. I understand that you prefer multiple lines. But if I use my syntax (SELECT...) I can put it all in one line. I am just trying to make my stored procedure, where I have to initialized tons of variable to a empty string, shorter (fewer lines so that it would be easier to read). Do you see anything wrong with this SELECT of multiple variables?
>>
>>Dmitry,
>>
>>I believe your way is a very good way and this is what I use myself. If I can set them all at once, I do it.
>
>Thank you for confirming this.
Perf nut in me agrees with one statement to execute,
but break up into multiple editor lines: they will still exec as one statement.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only