1 0 Archive | MS SQL RSS feed for this section
post icon

Adding data in MS SQL from one table to another table

INSERT INTO TestTable (FirstName, LastName)
SELECT FirstName, LastName
FROM Person.Contact
WHERE EmailPromotion = 2

for more details please check

Leave a Comment
November 1, 2013
post icon

MS SQL Server Update multiple table

Table A will be updated with data from Table B

UPDATE A
    SET A.NAME = B.NAME
FROM TableNameA A, TableNameB B
WHERE A.ID = B.ID
Leave a Comment
post icon
June 13, 2012