Viewing 2 posts - 1 through 2 (of 2 total)
You use one or the other.
Values is for a static set of data that you're inserting, when it's being typed into the query itself rather than pulled from another table.
INSERT...
February 10, 2020 at 9:22 pm
#3724516
You don't need VALUES (that's if you're not doing a select for the insert, but instead a list of static values).
INSERT INTO @multiVariable
SELECT ID, fName, address, state FROM baseTableExample;
February 7, 2020 at 8:55 pm
#3724057