Wednesday, February 27, 2013

Update with join example




UPDATE Cv
SET cv.Id = CT.Id
FROM XYZ.[dbo].[tblP] CV
INNER JOIN ABC.[dbo].[tblP]  CT
ON CV. Id = CT. Id
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...