CTE with insert and update in sql server 2008
134544
How can I reuse a Common Table Expression
142750
Using INSERT INTO...EXEC AT linked server into temp table fails with Msg 7391
26327
Solutions for INSERT OR UPDATE on SQL Server
38371
How to UPSERT (MERGE, INSERT ... ON DUPLICATE UPDATE) in PostgreSQL?
144149
How to split a string in sql server 2008 using stored procedure and insert the data to table
8888
How to insert a data table into SQL Server database table?
20682
In SQL Server, how do I generate a CREATE TABLE statement for a given table?
155901
Update a single row with t-sql
55963
One query to insert multiple rows with multiple columns
118632
How to set identity_insert to on in SQL Server
131790
SQL Server update primary key that's also a foreign key in two tables
79987
SQL - Inserting a row and returning primary key
36267
insert query with varchar as data type for primary key
112218
How do I UPDATE from a SELECT in SQL Server?
68033
Nested transactions in Sql Server
110522
Insert, on duplicate update in PostgreSQL?
148262
How can I do an UPDATE statement with JOIN in SQL Server?