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

How to learn Azure without paid subscription

Microsoft Azure is a cloud service that is constantly expanding to help your organization meet business challenges. You can build, manage d...

Subscribe to the FREE Weekly Newsletter to receive all the latest Microsoft Azure, AI, Xamarin

Popular Posts