sql server - Sql - Fetch next value to replace variable value -

hi guys basic sql knowledge needs

i want able replace variable value value in table , keep running query until end value in table reached

start query

declare @prime_schema varchar(20) declare @next_schema varchar(20) declare @table_name varchar(100) declare @sql varchar(500)  set @prime_schema = 'aaa' set @next_schema = 'bbb' set @table = 'table1'  set @sql = 'select top 1 * '+@next_schema +'.'+@table_name +' '+@prime_schema +'.'+@table_name +' truncate table '+@next_schema +'.'+@table_name  print @sql 

i want wrap in fetch , use table called 'table_val' update table_name value , loop around till rows have been used in table

so end multiple @sql statements

thanks

try 1 -

query:

declare        @prime_schema sysname = 'aaa'     , @next_schema sysname = 'bbb'  declare @sql nvarchar(max) select @sql = (     select char(13) + '         select *          [' + @next_schema + '].[' + o.name + ']         [' + s.name + '].[' + o.name + ']         1 != 1'     sys.objects o (nowait)     join sys.schemas s (nowait) on o.[schema_id] = s.[schema_id]     o.[type] = 'u'         , s.name = @prime_schema         , o.name in ('table1', 'table2', 'table3')     xml path(''), type).value('.', 'nvarchar(max)')  print @sql 

output:

select *  [bbb].[table1] [aaa].[table1] 1 != 1  select *  [bbb].[table2] [aaa].[table2] 1 != 1  select *  [bbb].[table3] [aaa].[table3] 1 != 1