Table Variable in SQL Server

Table Variable in SQL Server 1

The Table Variable in SQL Server stores a set of records like SQL tables. And Table Variables are the best alternative to Temp Tables. Like Local Variables, Table variable scope limited to User Defined Functions or Stored procedures. The SQL Table variable is very fast when compared to temporary tables, and it is recommended to use this for less … Read more