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 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..
|