Thursday, October 28, 2010
Update A (without using join)
UPDATE DailyAttendanceTable SET DailyAttendanceTable.Class = B.Class ,DailyAttendanceTable.[Division] = B.[Division],DailyAttendanceTable.[RouteNo] = B.[RouteNo],DailyAttendanceTable.[PickUpPoint] = B.[PickUpPoint],DailyAttendanceTable.[DropRouteNo] = B.[DropRouteNo],DailyAttendanceTable
.[DropDownPoint] = B.[DropDownPoint]FROM SCHULE_STUDENTDETAILS BWHERE DailyAttendanceTable.StudentId = B.StudentId
Subscribe to:
Post Comments (Atom)
rls
To enable row-level security (RLS) in MS SQL Server (2016 and later) , you need to define a security policy that uses a user-defined, inli...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
No comments:
Post a Comment