Quick flash back on MS SQL Server Code Names

Code Name	Final name
SQL95	SQL Server 6.0
Hydra	SQL Server 6.5
Sphinx	SQL Server 7.0
Shiloh	SQL Server 2000 (32-bit)
Liberty	SQL Server 2000 (64-bit)
Yukon	SQL Server 2005
Katmai / Akadia	SQL Server 2008
Kilimanjaro	SQL Server 2008R2
Denali	SQL Server 2012
Hekaton	SQL Server 2014

Reference: http://en.wikipedia.org/wiki/List_of_Microsoft_codenames#SQL_Server_family

SQL Server 2008 : T-SQL Enhancement

As we all know, SQL Server 2008 came up with a huge number of changes which are helpful for both developers as well as DBA's. In this post I will be demonstrating about once such enhancement that is very helpful for data insertion.

The usual syntax for inserting data to a table is 

Insert into tbl_TSQLEnhancement values (1,'Usual','SansSQL')

Insert into tbl_TSQLEnhancement values (2,'Usual','Blog')

Insert into tbl_TSQLEnhancement values (3,'Usual','T-SQL')

Insert into tbl_TSQLEnhancement values (4,'Usual','SQL Server 2008')

If we are inserting multiple records at a time then we will have to write statements as shown above. But from SQL Server 2008 onwards, it is made easy by giving an option to insert more than one record in a single T-SQL statement as shown below.

Insert into tbl_TSQLEnhancement values

       (1,'New','SansSQL')

      ,(2,'New','Blog')

      ,(3,'New','T-SQL')

      ,(4,'New','SQL Server 2008')

Cool feature right?

So now it's time to try it out yourself.

/* Create Table */

Create Table tbl_TSQLEnhancement

(Id int not null,

Method nvarchar(10),

Name nvarchar(20))

/* Insert Data to table using Usual method */

Insert into tbl_TSQLEnhancement values (1,'Usual','SansSQL')

Insert into tbl_TSQLEnhancement values (2,'Usual','Blog')

Insert into tbl_TSQLEnhancement values (3,'Usual','T-SQL')

Insert into tbl_TSQLEnhancement values (4,'Usual','SQL Server 2008')

/* Insert Data to table using New method */

Insert into tbl_TSQLEnhancement values

       (1,'New','SansSQL')

      ,(2,'New','Blog')

      ,(3,'New','T-SQL')

      ,(4,'New','SQL Server 2008')

/* Retrive Data */

Select * from tbl_TSQLEnhancement

/* Cleanup Process */

Drop table tbl_TSQLEnhancement

Difference between Getdate() and GetUTCDate()

GETDATE(): 

GETDATE()

 function returns the current database system timestamp. This value is derived from the operating system of the computer on which the instance of SQL Server is running. 

If you are connected to the SQL server remotely then the timestamp displayed will be the timestamp of the SQL server machine and not your local machine.

Usage: SELECT GETDATE() as [ServerTime]

GETUTCDATE(): 

GETUTCDATE() function returns the current UTC time. This value is derived from the operating system of the computer on which the instance of SQL Server is running. 

This can be used to store the timestamp that is independent of Time Zones.

Usage: 

SELECT GETUTCDATE() as [UTCTime]

MS SQL Server 2011 (Denali) Community Technology Preview 1 - Released

The Community Technology Preview (CTP) Version of MS SQL Server 2011 also know as 'Denali' is now available for download.
This is available in both 32 bit and 64 bit versions.
Click here to download CTP1 version of Denali.


To read about what's new in SQL Server 2011 code-named "Denali" - Community Technology Preview 1 (CTP1) click here.