zaagan
8/3/2019 - 9:50 AM

MS SQL Table Variable

MS SQL Table Variable

MS SQL Table Variable.sql
content_copyfile_download
DECLARE @MyTable TABLE (
   ID INT PRIMARY KEY,
   Col1 INT NOT NULL
);

INSERT INTO @MyTable (ID,Col1)
    VALUES (1,505);
    
SELECT ID,Col1
    FROM @MyTable