When we write SET NOCOUNT ON it means it will not return the messages of the number of rows affected. Why to use SET NOCOUNT ON in stored procedure? There are two types of Stored procedure in SQL Server, User defined store procedure and System store procedure Stored procedure is a reusable object can be called from different places with parameters.
Stored procedure is pre compiled and type safe, work faster than normal query during runtime. Stored procedure is a database object in sql Server,A stored procedure is a set of sql statements with some business logic written inside,compiled and stored in the database. In this tutorial you will learn how to create a stored procedure in sql server database, stored procedure is often termed as sql sp by database developer.
0 kommentar(er)
