XML FeedsC# is becoming more dynamic (like Python and Ruby) but now SQL is becoming more like C# (but with LINQ C# is becoming more like SQL)
Confused? Good!
SQL Server has added compound operators. Instead of writing
- SET @value = @value + 100
you can just do
- SET @value += 100
See that? I can see a lot of people writing Dynamic SQL already smiling. Really who wants to write code like this whole day long?
- SET @MyBigDynamicSQLString = MyBigDynamicSQLString + ' From ' + @Table
This is much shorter (but not better IMNSHO)
- SET @MyBigDynamicSQLString += ' From ' + @Table
Anyway here are all the compound operators that you can use:
+= (Add EQUALS)
Adds some amount to the original value and sets the original value to the result.
-= (Subtract EQUALS)
Subtracts some amount from the original value and sets the original value to the result.
*= (Multiply EQUALS)
Multiplies by an amount and sets the original value to the result.
/= (Divide EQUALS)
Divides by an amount and sets the original value to the result.
%= (Modulo EQUALS)
Divides by an amount and sets the original value to the modulo.
&= (Bitwise AND EQUALS)
Performs a bitwise AND and sets the original value to the result.
^= (Bitwise Exclusive OR EQUALS)
Performs a bitwise exclusive OR and sets the original value to the result.
|= (Bitwise OR EQUALS)
Performs a bitwise OR and sets the original value to the result.
Have fun reconstructing your strings :-)
Here is another example where SQL is morphing
- DECLARE @find varchar(30);
- SET @find = 'Man%';
In SQL Server 2008 you can do
- DECLARE @find varchar(30) = 'Man%';
Much nicer
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
I guess I'm getting old. I see no particular reason why this change is an 
I don't care much for the +=, -=, etc... I'm a huge fan of the better variable declaration though. 
I was sitting here a long time ago reading the new pocket guide on 2008 roughly going over several changes like forceseek, the extending of SQLCLR, backup compression and on until I got to page 28..started reading on row constructors and then flipped the page and saw a table with the first column "Operator" and when I saw += *sigh*, this big smile came over my face.
AFAIK VB also has += 
Really? 
Sweet!
What version is this coming to?
People write new applications in VB? Have no business learned? Or is it the price tag that comes with a VB programmer vs a REAL programmer. 
Okay, now how many things do you expect me to learn in a lifetime? 
Nice to know.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.