DP44/DataPRO_sql/dbo.sp_TestEngineerDetailsInsert.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestEngineerDetailsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestEngineerDetailsInsert]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestEngineerDetailsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestEngineerDetailsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestEngineerDetailsInsert]
		    @Name				nvarchar(255)
           ,@TestEngineerName	nvarchar(255)
           ,@TestEngineerPhone	nvarchar(255)
           ,@TestEngineerFax	nvarchar(255)
           ,@TestEngineerEmail	nvarchar(255)
           ,@LocalOnly			bit
           ,@LastModified		datetime
           ,@LastModifiedBy		nvarchar(50)
           ,@Version			int
		   ,@new_id				int				output
		   ,@errorNumber		int				output
		   ,@errorMessage		nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0);
	begin try
		insert into [dbo].[TestEngineerDetails]
				   ([Name]
				   ,[TestEngineerName]
				   ,[TestEngineerPhone]
				   ,[TestEngineerFax]
				   ,[TestEngineerEmail]
				   ,[LocalOnly]
				   ,[LastModified]
				   ,[LastModifiedBy]
				   ,[Version])
		values
				   (@Name				
				   ,@TestEngineerName	
				   ,@TestEngineerPhone	
				   ,@TestEngineerFax	
				   ,@TestEngineerEmail	
				   ,@LocalOnly			
				   ,@LastModified		
				   ,@LastModifiedBy		
				   ,@Version)			
		set @new_id = scope_identity()
	end try
	begin catch
		set @errorMessage	= error_message()
		set @errorNumber	= error_number()
	end catch;
END






























GO