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

AI Evolution Explained: GenAI vs LLMs vs AI Agents vs Agentic AI vs Intelligent AI

Artificial Intelligence (AI) is one of the most exciting technologies in our world today. But the terms that come with it like GenAI, LLMs, ...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts