How to create simple stored procedures in SQL Server - Select, Insert/Update, Delete

Think you have a table called [CallbackDates] which has included only two colums named ID and CallBackDate. Create table SQL Query as follow.

CREATE TABLE "CallbackDates" (
"ID" INT not null,
"CallBackDate" DateTime not null)

Then you can create stored procedures using SQL.

Stored procedure - Select

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_SelectCallbackDates]
 @ID int
AS
BEGIN
 SET NOCOUNT ON

 SELECT
  [ID],
  [CallbackDate]

 FROM [dbo].[CallbackDates]
 WHERE
  ([ID] = @ID)

END

Stored procedure - Insert

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_InsertCallbackDates]
 @ID int = NULL OUTPUT,
 @CallbackDate datetime

AS
BEGIN
 SET NOCOUNT ON

 INSERT
 INTO [dbo].[CallbackDates]
 (
  [CallbackDate]
 )
 VALUES
 (
  @CallbackDate
 )
 SELECT @ID = SCOPE_IDENTITY()
END

In this case I have used some proper naming types for the stored procedure name.

Stored procedure - Update


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_UpdateCallbackDates]
 @ID int,
 @CallbackDate datetime

AS
BEGIN
 SET NOCOUNT ON

 UPDATE [dbo].[CallbackDates]
 SET
  [CallbackDate] = @CallbackDate
 WHERE
  [ID] = @ID

END

Stored procedure - Delete

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_DeleteCallbackDates]
 @ID int

AS
BEGIN
 SET NOCOUNT ON

 DELETE
 FROM [dbo].[CallbackDatess]
 WHERE
  [ID] = @ID

END