SQL Server - Get List of All Stored Procedures from Database in SQL Server

Introduction: 

Here I will explain simple SQL Query to get list of all stored procedures from SQL Server database or How to get list of all stored procedures in SQL Server Database or How to Get list of all tables in SQL Server database. 

Description:

In previous articles I explained Pass table as parameter to stored procedure in SQL Server, Different types of joins in SQL Server, Difference between len & datalength functions in SQL Server, convert rows to columns in sql server without using pivot, Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server and many articles relating to SQL Server. Now I will explain how to get all tables and stored procedures in database using SQL Server.

SQL Server - Get List of All Table Names in Database

Introduction: 

Here I will explain simple SQL Query to get all table, procedure names in database or How to get list of all tables names in SQL Server Database or How to Get list of all procedures in SQL Server database.  

Description:

In previous articles I explained Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server, Exception handling in SQL Server stored procedure, Reading xml file using SQL Server and many articles relating to SQL Server. Now I will explain how to get all tables and stored procedures in database using SQL Server.

Create Database Schema Diagram in SQL Server

Introduction: 

Here I will explain how to create database schema diagram in SQL Server 2008.

Description:
  
In previous articles I explained Insert values in identity column in SQL Server, Check if string contains specific word in SQL, SQL Query to read xml file, SQL Query to get duplicate records count, SQL Query to convert lower case to upper case and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to create database schema diagram in SQL Server 2008.

To create database schema diagram in SQL Server 2008 you need to follow below steps

SQL Server - How to Find Total Number of Days in a Month

Introduction: 

Here I will explain how to get or find total number of days in month using SQL Server.

Description:
  
In previous articles I explained Insert values in identity column in SQL Server, Check if string contains specific word in SQL, SQL Query to read xml file, SQL Query to get duplicate records count, SQL Query to get month wise, year wise data and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to get or find total number of days in month using SQL Server.

To get total number of days in a month we need to write the query like as shown below

SQL Server - How to Delete Duplicate Records Rows from Table in SQL Server

Introduction: 

Here I will explain how to remove or delete duplicate records or rows from a table in SQL Server or Delete duplicate records / rows from table in SQL Server 2008.

Description:
  
In previous articles I explained SQL Query to get duplicate records count, SQL Query to convert rows to columns, SQL Query to get last inserted record id and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to remove duplicate records from a table in SQL Server.

To delete duplicate records or rows from datatable in SQL Server you need to check below article in that article I explained clearly how to delete duplicate records from SQL Server

Exception Handling in SQL Server Stored Procedure with TRY CATCH

Introduction: 

Here I will explain how to handle exceptions in SQL Server or exception handling in SQL Server for stored procedure by using try catch or error handling in SQL Server.

Description:
  
In previous articles I explained Pass table as parameter to stored procedure in SQL Server, Difference between joins in SQL Server, Convert rows to columns in SQL Server, SQL Query to get duplicate records count and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to handle exceptions in SQL Server.

To handle exceptions in SQL Server we can use TRY…… CATCH blocks. To use TRY…… CATCH blocks in stored procedure we need to write the query like as shown below

SQL Server - Add Identity Property to Existing Column in Table

Introduction: 

Here I will explain how to add identity property to existing column in table using SQL Server 2008 or add identity column to existing table SQL Server.

Description:
  
In previous articles I explained Create Identity Column or Auto increment column in SQL Server, Reset identity column in SQL Server, insert values in identity column in SQL Server, SQL Query to get month wise, year wise data and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to add identity property to existing column in table using SQL Server 2008.

SQL Server - How to Insert Values into Identity Column

Introduction: 

Here I will explain how to insert values in identity column in SQL Server. Identity columns are used to automatically assign new incremented value to identity column when new record inserted based on previous value in SQL Server.

Description:
  
In previous articles I explained Create Identity Column or Auto increment column in SQL Server, Reset identity column in SQL Server, SQL Query to get particular part of string, SQL Query to replace part of string, SQL Query to read xml file, SQL Query to get month wise, year wise data and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to insert values into an identity column in SQL Server.

SQL Server Check if String Contains Specific Word / String with CHARINDEX Function

Introduction: 

Here I will explain how to check if string contains specific word in SQL Server using CHARINDEX function or SQL Server check if string contains specific substring with CHARINDEX function. 

Description:
  
In previous articles I explained SQL Query to get particular part of string, SQL Query to replace part of string, kill all active database connections in SQL Server, SQL Query to read xml file, SQL Query to get month wise, year wise data and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to check if string contains specific word in SQL Server. 

To check if string contains specific word in SQL Server we can use CHARINDEX function.

C#- Insert Word Document Files into SQL Server Database Table

Introduction:

Here I will explain how to upload files to database in asp.net and download files from database in asp.net or save or insert word document in SQL Server database using asp.net in C#, VB.NET.

Description:
  
In previous articles I explained Save/Upload files in folder and Download files from folder, Save Images in folder and images path in database and show images from folder and many articles relating to asp.net, C#, VB.NET etc…. Now I will explain how to upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.

Close Kill All Active Database Connections in SQL Server

Introduction

Here I will explain how to kill or close all active database connections in SQL Server.

Description

In previous article I explained Get number of active connections to database in SQL Server, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to close or kill all database connections in SQL Server.

Get Number of Active Connections to Database in SQL Server

Introduction

Here I will explain how to get or find number of active connections to database in SQL Server. 

Description

In previous articles I explained Read XML file data using SQL Server, Joins in SQL Server, Get Latest Unique Records by count in SQL Server, Insert data with apostrophe in SQL Server, Convert Rows to Columns in SQL and many articles relating to SQL Server.  Now I will explain how to get or find number of active connections to database in  SQL Server.

SQL Sever- Reading XML Data File using SQL Query Example | Read XML Data Type in SQL Server

Introduction:

Here I will explain how to write a query to read xml data file or read xml data type with simple example using SQL Server.

Description:

In previous articles I explained Pass XML file as a parameter to stored procedure, read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to write a query to read xml data in SQL Server.

Pass XML as Parameter from C# to SQL Stored Procedure in VB.NET

Introduction:

Here I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

Description:

In previous articles I explained read xml node values and bind data to gridview, how to insert and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to pass or send xml file as a parameter to SQL stored procedure in asp.net using C# and VB.NET.

SQL Query to Get Latest Unique Records by Date

Introduction:

Here I will explain how to write query to get latest or recent records but unique records in SQL Server.

Description:

In previous articles I explained joins in SQL Server, Get Records without weekends, SQL Query Get Month Wise Data, difference between function and stored procedures, and many articles relating to SQL Server. Now I will explain how to write a query to get latest or recent records but unique records in SQL Server.

SQL Query to Get Month wise Data, Year wise Data

Introduction

In this SQL Server article I will explain how to write query to get monthly (month wise) data or year wise data from database.

Description

In previous articles I explained Query to get Exclude weekends in SQL Query, While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to write query to get month wise data or year wise data from database in SQL Server.

How to Exclude Weekends in SQL Query or Get Records Without Weekends

Introduction:

In this SQL Server article I will explain how to write query to get records Exclude weekends data or without weekends data in SQL Server.

Description:

In previous articles I explained insert single quote data in database, DateAdd function Example, Pass table as parameter to procedure, difference between function and stored procedures, joins in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to get records without weekend’s data in SQL Server.

SQL Server Insert Data with Apostrophe/Single Quote in Database

Introduction

In this SQL Server article I will explain how to insert single quote or apostrophe data in database.

Description

In previous articles I explained While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to insert single quote or apostrophe data in SQL Server.

SQL Server Nested WHILE Loop Example

Introduction

Here I will explain how to use nested while loops in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Break or Exit while loop in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server. Now I will explain how to use nested while loops in SQL Server.

SQL Server EXIT or BREAK from WHILE Loop with Example

Introduction

Here I will explain how to exit from while loop in SQL Server or how to break from while loop in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to break or exist while loop in SQL Server with example.