-
SQL Server Insert
How can I insert the results of a view into a table which has already been designed and has extra columns in it?
The problem is the extra columns. I tried
INSERT [view] INTO [table]
I also tried to use update. but with no records in the table it would not work. I also tried insert into but that isn't really practical since I have to drop the table to recreate it.
-
INSERT INTO [Table] ([Field1], [Field2], ...) VALUES ([Value1], [Value2],...)
For variables:
INSERT INTO [Table] ([Field1], [Field2], ...) VALUES ('" & [Value1] & "', '" & [Value2] & "', '"...)