SQL Server stored procedure

Create a SQL Server stored procedure

How to create a simple SQL Server stored procedure? This example in transact SQL code list all the Customers from the Customers table by using the selection function. This example do not use any where clause to filter the results. Its a simple example to remind the syntax creation for

SQL Server stored procedure

Alter a SQL Server stored procedure

How to alter an existing stored procedure in a SQL Server database? Simply use the alter command instead of the create command one to modify an existing SQL procedure. In this example let’s add the grouping on months and employees to sum up and group data. Let’s add also a

blank
SQL Server Index

How to drop a SQL Server index?

This article is on how to drop a SQL Server index from an existing table on a given database. It can be a relational or a transactional database. For instance, learn here why you need an index optimization plan on databasejournal. How to drop a SQL Server index? To drop

blank
SQL Server stored procedure

Create a SQL Server stored procedure with parameters

How to create a Sql Server stored procedure with input parameters ? As a reminder, a stored procedure schedules and groups a set of T-SQL queries. How can we integrate a simple SELECT query on the Customers table of our database into a stored procedure? For example, instead of displaying