New post in Table-variable

T-SQL Table variable with case sensitive columns - collate SQL_Latin1_General_CP1_CS_AS

June 18th, 2022

collate sql-server tsql table-variable

Structured types must have at least one field c#

July 25th, 2022

sql-server table-variable c# stored-procedures

Inserting multiple rows into a SQL Server table using a table variable

July 30th, 2022

insert sql sql-server-2008 table-variable

How to check if a table variable is empty in SQL Server?

March 11th, 2020

sql-server table-variable null tsql

How to view data in table variables during debugging session in MS SQL Management Studio 2012?

April 28th, 2020

debugging table-variable ssms sql-server-2012

How to take table name as an input parameter to the stored procedure?

January 30th, 2022

table-variable sql-server stored-procedures

Creating table variable in SQL server 2008 R2

September 19th, 2020

table-variable sql-server-2008

How to fix "Must declare the scalar variable" error when referencing table variable?

June 29th, 2020

sql-server table-variable tsql

How can I reseed an identity column in a T-SQL table variable?

May 22nd, 2020

table-variable sql-server tsql

TSQL Define Temp Table (or table variable) Without Defining Schema?

February 22nd, 2020

temp-tables tsql sql-server table-variable schema

Table variable error: Must declare the scalar variable "@temp"

July 9th, 2022

table-variable sql-server tsql

How do I drop table variables in SQL-Server? Should I even do this?

July 8th, 2022

sql-server sql table-variable

Creating an index on a table variable

June 1st, 2020

table-variable sql indexing sql-server tsql

When should I use a table variable vs temporary table in sql server?

July 3rd, 2020

temp-tables sql-server table-variable

What's the difference between a temp table and table variable in SQL Server?

November 20th, 2021

temp-tables table-variable sql-server

SELECT INTO a table variable in T-SQL

December 22nd, 2020

insert table-variable sql-server tsql

Can I loop through a table variable in T-SQL?

December 23rd, 2021

tsql sql sql-server database-cursor table-variable

How to use table variable in a dynamic sql statement?

July 5th, 2022

sql sql-server sql-server-2008 table-variable dynamic-sql

How to use a table variable in an "update from select" query?

June 4th, 2022

sql table-variable tsql sql-server-2005 sql-server

Why are temporary tables faster than table variables for joins?

June 5th, 2022

temp-tables table-variable join sql-server

Very slow DELETE query

June 16th, 2022

performance table-variable sql sql-server sql-execution-plan