Skip to main content

Posts

Showing posts with the label 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
Read more