Using Update, Delete statements in SQL

Hi All,

following are the some important points which should be kept in mind while dealing with insert, update, delete statement.

1) Always use update and delete statement in transaction i.e by using explicit commit.

2)Before executing update and delete statement, first create them on the basis of select satement.

3)Finally before executing the update and delete query on the production server always keep habit to execute it on the non-production server.
Ebook Download
View all
Learn
View all