insert stored procedure in sql server 2008 with example

Insert Stored Procedure in SQL Server 2008

This is basically Insert Stored Procedure in SQL Server 2008


USE [testDB]
GO
/****** Object:  StoredProcedure [dbo].[AddContract]    Script Date: 07/04/2014 21:43:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[AddContracts]
(  
  @ID INT
 ,@CTypeID INT
 ,@TrialDays INT
 ,@StartDate DATETIME
 ,@EndDate DATETIME
)
AS
BEGIN
 Insert Into Contract
  (
    ID
   ,CTypeID
   ,TrialDays
   ,StartDate
   ,EndDate
  )
  values
  (
    @ID
   ,@CTypeID
   ,@TrialDays
   ,@StartDate
   ,@EndDate
  )

 IF(@@ERROR = 0)
         SELECT 1
 ELSE
        SELECT -1

END

ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^