Microsoft Tech*Ed 2008, Orlando Florida (Update)
I predict that SQL server 2008 is going to be a huge hit. It has been designed for performance and scalability from the start.
Some of the new features:
- Table Valued Parameters - stored procedures will accept a table parameter. ADO.NET has been modified so from C#, etc you can create a new variable called ‘SqlDBType.Structure‘ and pass this onto your stored procedures. This is huge! No more temporary tables, or cursors to emulate the same behavior.
CREATE TYPE CustomersTableType AS TABLE (NAME VARCHAR(25), LASTNAME VARCHAR(25));
CREATE PROCEDURE UpdateCustomers(@CUSTOMERS CustomersTableType REAONLY)
AS
BEGIN
INSERT INTO CUSTOMERS (NAME, LASTNAME)
SELECT NAME, LASTNAME FROM @CUSTOMERS;
END; - New date/time data types: date, time, and also same times but time zone aware
DATE - holds date from 1/1/1 to 12/31/9999
TIME - holds timeaccurate up to 100 nanoseconds
DATETIMEOFFSET - time zone aware. Stores value in UTC format
DATETIME2 - holds date & time with larger precision - New geo-spatial (latitude/longitude) data types -SQL server understand natively coordinates so you can create location aware applications. For instance, get me all the customers within a 10 miles radius
(more…)