SQL Stored Procedure Archives - Technology with Vivek Johari

Difference between Stored Procedure and Trigger

November 1, 2018 vivekjohari15 Comments

Difference between Stored Procedure and Trigger SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a specific task. Trigger are also similar to SQL Stored procedure as they can also be a […]

Advantages of SQL Stored Procedure

November 1, 2018 vivekjohari32 Comments

SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task. Stored procedure are better than the inline SQL queries as they help in securing the database from SQL Injection. It also help in increasing the performance of the Database. There are many other Advantages of SQL […]

Sql Server- Difference between Stored Procedure and Function

December 22, 2009February 1, 2019 vivekjohari6 Comments

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions. These differences can be summarized as follows:- 1) A stored procedure can return a value or it may not return any […]

Sql Server – How to write a Stored procedure in Sql server

December 5, 2009February 1, 2019 vivekjohari42 Comments

Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of using a stored procedure. The main benefit of using a stored procedure is that it increases the performance of the database.The other benefits […]