Select/Delete All tables WHERE

by 
		DECLARE
		@Count int = 1,
		@NumRows int,
		@strSQL varchar(MAX)

	Declare @schema_name varchar(32)
	Declare @table_name varchar(32)


	SELECT @NumRows= COUNT(*) FROM [Util].[TableList] WHERE [schema_name] = 'dbo'
	WHILE @Count<= @NumRows 

		SELECT @schema_name =  [schema_name]  FROM [Util].[TableList] WHERE [schema_name] = 'dbo' AND RowNum = @Count
		SELECT @table_name =  [name]  FROM [Util].[TableList] WHERE [schema_name] = 'dbo' AND RowNum = @Count

--		SET @table_name = 'DIM_PROJ_FORECAST_OL'

		SET @strSQL = 
--		'SELECT * '
		'DELETE '
		+ ' FROM [' + @schema_name + '].[' + @table_name + ']'
		+ ' WHERE'
		+ ' IFS_INSTANCE = '+ char(39) + 'SPDAS' + char(39) + 
		';'

		EXEC(@strSQL)

		SET @Count= @Count + 1

Leave a Comment