Sql Server Interview Questions

What are difference between the temp table and table variable in SQL Server?

Post Views: 372  Temporary Variables: 1) The temp table can be created using the #sign and table name. — Create Temporary TableCREATE TABLE #Employee (Id INT, Name VARCHAR(50)) –Insert Two rows INSERT INTO #Employee VALUES(1,’Ram’) INSERT INTO # Employee VALUES(2,’Karan’) –Retrieve the records from temp table SELECT * FROM #Employee –DROP Temporary Table query DROP […]

Tech Contents © 2016
Inline
Inline