Table variable name
Columns (name + datatype)
Clear table
Copy all SQL
Paste from Excel: tabs → columns, newlines → rows. SQL updates automatically.
Column names should be like
col1
(no spaces). Types use suggestions but accept any text.
Input table
T-SQL output