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
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers