Category Archives: SQL Stored Procedure

SQL Stored Procedure

Difference between Stored Procedure and Trigger

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 … Continue reading

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 Comments

Advantages of SQL Stored Procedure

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 … Continue reading

Posted in SQL Server, SQL Stored Procedure | Tagged , , | 32 Comments

Sql Server- Difference between Stored Procedure and Function

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 … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Functions, SQL Server, SQL Stored Procedure | Tagged | 6 Comments

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

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  … Continue reading

Posted in Most Imp SQL Concepts, SQL Server, SQL Stored Procedure | Tagged , , | 42 Comments