Avoid Temp Table use Table Data Type

Avoid Temp Table use Table Data Type

Micrsoft indroduced table data type in sql server altenative to using temporary table
Table variables store a set of records, so naturally the declaration syntax looks very similar to a

CREATE TABLE statement, as you can see in the following example:
DECLARE @Student TABLE
{
SNO INT ,SNAME NVARCAHR
}

IF YOU WANT INSERT RECORD
INSERT INTO @ Student VALUES(2,’JSSUTHHAAR’)
OR
INSERT INTO @Student SELECT SNO,SNAME FROM STUDENT

0 Comments

Featured Post

MSDEVBUILD in Feedspot Top 100 Microsoft Azure Blogs

I am pleased to announce my blog msdevbuild.com again has been listed on the popular Feedspot website as one of the Top 100 Microsoft Azure...

Popular Posts