SQL Stored Procedure Archives - Page 12 of 30 - SQL Authority with Pinal Dave

MySQL – How to Create Stored Procedure in MySQL

May 2, 2014

MySQL supports Stored Procedures which can execute set of codes by applying relevant business logics. In this post we will see how to create a stored procedure and execute it. Let us create the following tables CREATE TABLE items(item_id INT, item_description VARCHAR(100)); CREATE TABLE sales(sales_id INT auto_increment KEY,item_id INT, sales_date…

SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running

March 15, 2014

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Stored Procedure

Here is one of the very common interview questions I often ask people – Q: What is the default Port SQL Server running on? A: 1433 for TCP/IP and 1434 for USD connection. I always get the correct answer for this question. However, when I ask a follow up question,…

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

March 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

A very common question which I often receive is – “How big my table name can be?” The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. Execute following stored procedure in SQL Server. EXEC sp_server_info It will return following resultset. attribute_id…

SQL SERVER – Select Columns from Stored Procedure Resultset

September 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the…

SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server

August 2, 2013

Pinal Dave

SQL Tips and Tricks

Disk, SQL Scripts, SQL Server, SQL Stored Procedure

A very common question I often receive is how to detect if the disk space is running low on SQL Server.

SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods

May 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Here is a very common question which I keep on receiving on my facebook page as well on twitter. “How do I insert the results of the stored procedure in my table?” This question has two fold answers – 1) When the table is already created and 2) When the…

SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

April 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Here is one of the very common question I receive on SQLAuthority Facebook page. I usually answer them on Facebook but this one I find it very interesting so I decided to answer here. “There are few of the stored procedure when I try to execute they return following message. Would…