IF OBJECT_ID ( 'dbo.testproc', 'P' ) IS NOT NULL
DROP PROCEDURE dbo.testproc;
CREATE PROCEDURE dbo.testproc
SET NOCOUNT ON;
DECLARE @cmd as nvarchar(4000);
SET @cmd = '
if ... drop function
CREATE FUNCTION ....'
set @cmd = ' use the function here'
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.