DynamicSqlPart1.sql

DECLARE @meta AS TABLE (
	[schema_name] varchar(128),
	[table_name] varchar(128),
	[column_name] varchar(128),
	[company_id] int,
	[row_count] int,
	[value_found] varchar(128),
	[search_value] varchar(128),
	[update_script] nvarchar(1000),
	[delete_script] nvarchar(1000)
)

DECLARE
	@schema_name varchar(128),
	@table_name varchar(128),
	@column_name varchar(128),
	@value_found varchar(128)
	
DECLARE @row_count int, @company_id int

DECLARE @SQL NVARCHAR(2000), @USQL NVARCHAR(1000), @DSQL NVARCHAR(1000)

-- Declare a search operator, typically either LIKE or =
DECLARE @SearchOperator varchar(20)
--SET @SearchOperator = ' LIKE '
SET @SearchOperator = '='

-- Declare the value we are searching for
DECLARE @SearchValue varchar(128)
--SET @SearchValue = 'SP%'
SET @SearchValue = '36'

-- Declare the replacement value we will use
DECLARE @NewValue varchar(128)
SET @NewValue = '4'