SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ntm_test_delete_node]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ntm_test_delete_node] GO -- converts from node_name to node_id. CREATE PROCEDURE ntm_test_delete_node @TreeID uniqueidentifier ,@node_name varchar(255) ,@node_table_name varchar(255) = 'ntm_nodes' ,@str_debug varchar(255) = "NODEBUG" as declare @errormessage_str varchar(255) declare @sql_str nvarchar(1000) DECLARE @deleteID uniqueidentifier begin if @TreeID is null begin set @errormessage_str = 'Error - The TreeID can not be null.' goto errorhandler end set @sql_str = N'select @DeleteID = InternalNodeID from ' + @node_table_name + N' where TreeID = ''' + convert(nvarchar(50), @TreeID) + N''' and NodeName = ''' + @node_name + N'''' execute sp_executesql @sql_str, N'@DeleteID uniqueidentifier out', @DeleteID out exec ntm_delete_node @node_table_name=@node_table_name, @TreeID=@TreeID, @DeleteId=@DeleteID /* return the success status code */ return(1) ErrorHandler: Print '*** Error While Executing NTM_TEST_DELETE_NODE ***' Print @ErrorMessage_str /* return the error status code */ return(-1) end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO