Vb.net Development and SQL Hints
Saturday, 22 October 2016
Update from Test Database to Running Database
Update TaskUpdate Set TaskEndTime = b.TaskEndTime
From TaskUpdate a
Inner Join testproduction.dbo.TaskUpdate b on a.DetTranId = b.DetTranId
and a.MasTranId = b.MasTranId and a.EntryDate = b.EntryDate
and a.TaskStartTime = b.TaskStartTime
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment