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

Azure AI Service, Studio, ML & Foundry – Which One Do You Need?

If you have used Microsoft AI tools in the past, you might remember popular services like Cognitive Services and the Bot Framework. These to...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts