Tag: Stored Procedure

Best practices for Stored Procedures in SQL Server

Read the following blog post for Best Practices to be followed for designing the tables in SQL Server. Best practices for designing tables in SQL Server SET NOCOUNT ON and TRANSATION ISOLATION LEVEL READ UNCOMMITED should be there at the beginning of Stored Procedure. All temporary tables should be created in the beginning. All the … Continue reading Best practices for Stored Procedures in SQL Server

Advertisements