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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book