All Articles on SQL - Stored Procedures

Transactions make sure a series of updates to the database happen together or else rollback gracefully.

Usually the identity column will be used to create a unique key value in a table. Sometimes though finding the next no by using the current values is useful.

Sometimes you don't know if the record exists in the table and the insert / update should be carried out within the one stored procedure call. Heres how.