SQL Server

SQL Server

Create PIVOT From SQL Server Table

In this article, I will explain you how to create a pivot from two columns (Sales date and Sales Amount) in sql Table. Create a table “Monthly_Sales” by using the following Query. Create table Monthly_Sales( […]

Get All Table names from SQL Server Database

In this article, I will explain how to get all table names from SQL Server Database. The below mentioned query will list all the table names available in the database. select Table_Catalog, Table_Schema, Table_Name, Table_Type […]

Get All Stored Procedures names from SQL Server Database

In this article, I will explain how to get all stored procedure names from SQL Server Database. The below mentioned query will list all the stored procedures (Routines) available in the database. select Routine_Catalog, Routine_Schema, […]