DP44/DataPRO_sql/.svn/pristine/bd/bda88f22523e20c1eb1d0217ee97193b4a75cd09.svn-base

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_CustomerDetailsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_CustomerDetailsInsert]
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_CustomerDetailsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_CustomerDetailsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_CustomerDetailsInsert]
			@Name					nvarchar(255)
           ,@CustomerName			nvarchar(255)
           ,@CustomerTestRefNumber	nvarchar(255)
           ,@ProjectRefNumber		nvarchar(255)
           ,@CustomerOrderNumber	nvarchar(255)
           ,@CustomerCostUnit		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)

	SET NOCOUNT ON;
	INSERT INTO [dbo].[CustomerDetails]
           ([Name]
           ,[CustomerName]
           ,[CustomerTestRefNumber]
           ,[ProjectRefNumber]
           ,[CustomerOrderNumber]
           ,[CustomerCostUnit]
           ,[LocalOnly]
           ,[LastModified]
           ,[LastModifiedBy]
           ,[Version])
     VALUES
           (@Name					
           ,@CustomerName			
           ,@CustomerTestRefNumber	
           ,@ProjectRefNumber		
           ,@CustomerOrderNumber	
           ,@CustomerCostUnit		
           ,@LocalOnly				
           ,@LastModified			
           ,@LastModifiedBy			
           ,@Version)
	set @new_id = SCOPE_IDENTITY();			

END






























GO