honza.mf (5/19/2010)
Maddy...! (5/19/2010)
hello frnds....wht ever it may be in order to run completely a block of t-sql code it should be syntax error free
i think there is no += operator in database so the code itself is wrong and u cant even think of it running how can you expect us to post answer for it.......
This code is valid!
+= operator is legal in the current version of SQL Server.
I expect people to answer questions without running code. I know, I'm old enough to be so naive.
You should specify which environment is used in the question. As a SQL 2005 user, I saw that there would be an error. You even don't have to run the code to see that.
I cannot guess which environment you had in mind.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP