Results for "Stored Procedure"
6 / 72 posts
Filter by Category
Understanding Stored Procedures in MSSQL
What is a Stored Procedure? A stored procedure is a group of SQL statements that are compiled and saved in the database. Instead of writing the same SQL qu…
Stored Procedure in MySQL
Syntax for Creating a Stored Procedure DELIMITER // CREATE PROCEDURE procedure_name (IN param1 data_type, OUT param2 data_type) BEGIN -- SQL statements END…
SQL Server Deadlock & Performance Monitoring Made Easy
Introduction In SQL Server, performance issues are very common. Sometimes queries run slow, sometimes users get stuck, and sometimes the system becomes unres...
What is Functions and Difference between Functions and Stored Procedures in SQL Server
What is a Function in sql : A function is a set of SQL Statements that perform a specific task. Basically, it is a set of SQL statements that accept only i…
SYS and INFORMATION_SCHEMA
...s schema is a special schema that contains system views and stored procedures that provide metadata about the SQL Server…
Dynamic Linked Server Management in SQL Server
Introduction In SQL Server, sometimes we need to connect with another database server. This is done using a Linked Server . But manually creating and deletin...