SQL Safety
Updated: 23 Aug 2007 | 1 comment
Every query that you run on a SQL database that modifies data in some way, has the potential of causing damage if it has not been written correctly.
Luckily for us, there are a few commands that can be used in order to help prevent this type of user error.
BEGIN TRANSACTION - Run this before running your query.
COMMIT TRANSACTION - Run this after running your query, only if it was successful and did what you wanted it to.
ROLLBACK TRANSACTION - Run this is your query did something nasty.
blog entry Filed Under:
About Endpoint Management Community Blog
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog. Filter by:
Blog Tags
Configuring Altiris Client Management Suite Altiris Deployment Solution Symantec Management Platform (Notification Server) Wise Packaging Basics Altiris Server Management Suite Best Practice Compatibility Tip/How to Helpdesk Solution Altiris IT Asset Management Installing Workflow Solution Ghost Solution Suite Windows Reporting Performance Upgrade Features ServiceDesk 7.x Database Agents Dell Management Products
Comments
useful
very very useful :-)
Tks SK ;-)
Would you like to reply?
Login or Register to post your comment.