INSERT INTO Table2 (col1, col2) SELECT col3, col4 FROM Table1 How about a bit detailed example using the following sample database structure. Table1 =========== Tbl1_ID (going to assume an auto increment here) FK_Tbl2_ID Data_Copy Table2 =========== Tbl2_ID Data Query1: Select Tbl2_ID From Table2 Where Data = 1 For every returned record from query1 it should [...]
Here is something that got me for a while today, escaping characters in MsSQL. I went through and tried the normal \ then thought I was losing it and tried the other slash /. However for some odd reason Microsoft went with the single tick ‘. So for example a mssql query using the escape [...]