Welcome to Foxite.COM Community Weblog Sign in | Join | Help

Two Features In SQL2008

In this case we can see two features en SQL2008, no more interesting but functionalities.

New datatype , date and intellisense in code editor.

 

Published Saturday, February 02, 2008 8:21 PM by frankling
Filed Under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Two Features In SQL2008

Thursday, February 07, 2008 4:45 PM by Cetin Basoz
I think the ability to save varchar(max), varbinary(max), image columns on disk is another great interesting feature (cool those files doesn't count in 4Gb limit of Express).
Also there are other like:
-Inserting multiple records with row constructors. ie:
insert into Customer (customerID,Company)
values
(1,"c1"),
(2,"c2"),
(3,"c3"),
(4,"c4")

-Merge
-Grouping sets
-Creating a table type and sending that table to a stored procedure as a parameter (aka. user defined tables and table parameters)
-HierarchyID datatype

Date and Time datatypes get the lion share but I think others are really more important new features.

What do you think?

(required) 
required 
(required)