DP44/DataPRO_sql/dbo.sp_LabratoryDetailsUpdate.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_LabratoryDetailsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_LabratoryDetailsUpdate]
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_LabratoryDetailsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_LabratoryDetailsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_LabratoryDetailsUpdate]
			 @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
		declare @LabratoryId int
		set @LabratoryId = [dbo].[foo_IdGetLabratory](@Name)

		set @new_id = @LabratoryId

		UPDATE [dbo].[LabratoryDetails]
		   SET [LabratoryName]					= @LabratoryName				
			  ,[LabratoryContactName]			= @LabratoryContactName		
			  ,[LabratoryContactPhone]			= @LabratoryContactPhone		
			  ,[LabratoryContactFax]			= @LabratoryContactFax		
			  ,[LabratoryContactEmail]			= @LabratoryContactEmail		
			  ,[LabratoryTestRefNumber]			= @LabratoryTestRefNumber		
			  ,[LabratoryProjectRefNumber]		= @LabratoryProjectRefNumber	
			  ,[LastModified]					= @LastModified				
			  ,[LastModifiedBy]					= @LastModifiedBy				
			  ,[LocalOnly]						= @LocalOnly					
			  ,[Version]						= @Version					
		 WHERE [LabratoryId]					= @LabratoryId
	end try
	begin catch
		set @errorMessage	= error_message()
		set @errorNumber	= error_number()
	end catch;
END






























GO