What are the advanced Features With SQL2008 over SQL2005 Particularly with TSQL
+2
A:
The big one for me, although it's not really T-SQL related, is intellisense. About time too :)
As for the language...
T-SQL finally got shortcut assignment in 2008:
SET @var *= 1.18
The MERGE
statement allows all sorts of modification goodness, based on the results of joining tables together.
There are a bunch of GROUP BY enhancements, like GROUPING SETS, and operations on cubes.
There are new datatypes to play with
- hierarchyid, useful in self-referencing datasets
- date and time can be treated separately
- geography and geometry, for GIS systems and other geographical applications
There are a few others too. See the official new features page for more.
Jeremy Smyth
2009-07-02 02:51:30
+1
A:
Hi
There are new features like-
- Compound Assignment Operators i.e. +=, -= etc.
- Increased size support for user defined data types.
- Four new date and time data types.
It is all covered here - http://technet.microsoft.com/en-us/library/cc721270.aspx
cheers
Andriyev
2009-07-02 02:53:53
+1
A:
There is Standard way to insert many rows with single INSERT statement:
INSERT INTO Tab VALUES (...,...,...), (...,...,...), ... (...,...,...)
msi77
2009-07-02 05:58:38