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
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
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
No comments: