IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_LabratoryDetailsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_LabratoryDetailsInsert]
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_LabratoryDetailsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_LabratoryDetailsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_LabratoryDetailsInsert]
			@Name						nvarchar(255)
			,@LabratoryName				nvarchar(255)
			,@LabratoryContactName		nvarchar(255)
			,@LabratoryContactPhone		nvarchar(255)
			,@LabratoryContactFax		nvarchar(255)
			,@LabratoryContactEmail		nvarchar(255)
			,@LabratoryTestRefNumber	nvarchar(255)
			,@LabratoryProjectRefNumber	nvarchar(255)
			,@LastModified				datetime
			,@LastModifiedBy			nvarchar(50)
			,@LocalOnly					bit
			,@Version					int
			,@new_id					int				OUTPUT
			,@errorNumber				int				output
			,@errorMessage				nvarchar(250)	output 
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	begin try
		SET NOCOUNT ON;
		INSERT INTO [dbo].[LabratoryDetails]
			   ([Name]
			   ,[LabratoryName]
			   ,[LabratoryContactName]
			   ,[LabratoryContactPhone]
			   ,[LabratoryContactFax]
			   ,[LabratoryContactEmail]
			   ,[LabratoryTestRefNumber]
			   ,[LabratoryProjectRefNumber]
			   ,[LastModified]
			   ,[LastModifiedBy]
			   ,[LocalOnly]
			   ,[Version])
		 VALUES
			   (@Name						
			   ,@LabratoryName				
			   ,@LabratoryContactName		
			   ,@LabratoryContactPhone		
			   ,@LabratoryContactFax		
			   ,@LabratoryContactEmail		
			   ,@LabratoryTestRefNumber		
			   ,@LabratoryProjectRefNumber	
			   ,@LastModified				
			   ,@LastModifiedBy				
			   ,@LocalOnly					
			   ,@Version)
		set @new_id = scope_identity();
	end try
	begin catch
		set @errorMessage	= error_message()
		set @errorNumber	= error_number()
	end catch;
END






























GO