Doing @variable+= @variable2 in T/SQL procedure

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

Doing @variable+= @variable2 in T/SQL procedure

Author

Message

CodeChargenewbie

Posts: 114

Posted: 10/18/2007, 9:15 AM

I'm writing a T/SQL procedure (on SQL Server of course) and the following statement is not working:

SET @variable += @variable2;

I get a "Incorrect syntax near '+' " error. Is it possible to even do this or must I type the whole thing out (i.e. SET @variable = @variable + @variable2;)?

thank you

CodeChargenewbie

Posts: 114

Posted: 10/18/2007, 9:24 AM

nevermind, sorry. It doesn't appear SQL Server has that type of functionality built-in.

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login