SQL Tips & Tricks

DECLARE @A AS TABLE (Rowid INT IDENTITY , LocationId INT)

INSERT INTO @A(LocationId)

SELECT 10 LocationId

INSERT INTO @A(LocationId)

SELECT 11 LocationId 

SELECT * FROM @A

Rowid    - LoacationId

1.       10

2.       11

DECLARE @B AS TABLE (Rowid INT IDENTITY, LocationId INT)

INSERT INTO @B(LocationId)

SELECT 12 LocationId

INSERT INTO @B(LocationId)

SELECT 15 LocationId

SELECT * FROM @B

Rowid    - LoacationId

1.       12

2.       15

UPDATE @A SET A.LocationId = B.LocationId FROM @A A, @B B

WHERE A.Rowid = B.Rowid

SELECT * FROM @A

Rowid    - LoacationId

1.       12

2.       15