SQL Server Summary

Recently I has got some free time and go through the knowledge about SQL Server.write this acticle in order to review in the Future.

1. Join Option

Join is important option in relational database. There is many types of join including Inner join, Outer join and cross join.

Some Important Tips:

2. Transaction:

• Transaction Features (ACID): atomicity, consistency, isolation and durability
• Transaction Template

--Transaction TemplateCREATE TRANSACTION [Name] asBEGINTRYBEGIN TRANSACTION        --Execute Code    COMMIT TRANSACTIONENDTRYBEGINCATCHIF(@ @TRANCOUNT >0)        ROLLBACK TRANSACTION    END IFENDCatch

SQL Server Summary