Posted By

choasis on 12/28/09

Tagged

copy

Versions (?)

Last Edited at 12/28/09 03:30am

Statistics

Viewed 833 times

Favorited by 1 user(s)

Related snippets

Copy rows from one table to another

/ Published in: SQL

Just replace the squared brackets with the correct values.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

INSERT INTO [TABLE2] AS T2 (NOLOCK) (T2.[VAL1], T2.[VAL2], ...)
SELECT T1.[VAL1], T1.[VAL2], ...
FROM [TABLE1] AS T1 (NOLOCK)
WHERE T1.[VAL1] = T2.[VAL1]

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.