dbo.QBM_PGICountTablesUsedByCode

1   create   procedure QBM_PGICountTablesUsedByCode( @Statements QBM_YCursorbuffer readonly  , @CodeName varchar(30)  , @CodeType varchar(30)  , 
2@OpenParenthesis nvarchar(max)   , @CloseParenthesis nvarchar(max)  )  as begin declare @SQLCmd nvarchar(max) declare @ElementCount int declare @ElementIndex
3 int declare @CountRefereced int = 0  declare @DebugSwitch int = 0 SET XACT_ABORT OFF BEGIN TRY set nocount on select @ElementCount = count(*) from @Statements
4 select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select @SQLCmd = concat( 'drop ', @CodeType, ' if exists dbo.', @CodeName) exec sp_executesql
5 @SQLCmd select @SQLCmd = concat ( @OpenParenthesis, s.ContentFull , @CloseParenthesis ) from @Statements s where s.ElementIndex = @ElementIndex if @DebugSwitch
6 > 0 begin print @sqlcmd end exec sp_executesql @SQLCmd select @CountRefereced += dbo.QBM_FGICountTablesUsedByCode(@CodeName) if @DebugSwitch > 0 begin
7 print '@CountRefereced ' + str(@CountRefereced) end select @SQLCmd = concat( 'drop ', @CodeType, ' if exists dbo.', @CodeName) exec sp_executesql @SQLCmd
8 select @ElementIndex += 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() 
9RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel:  return(@CountRefereced) end 
10