insert into T+(select schemaId from arschema where viewName='L_AL_Appending') values('1','1','1')
怎么将T和+(select schemaId from arschema where viewName='L_AL_Appending')连接起来
怎么将T和+(select schemaId from arschema where viewName='L_AL_Appending')连接起来
select @s='insert into T'+schemaId+' values( ''1'',''1'',''1'')' from arschema where viewName='L_AL_Appending'
exec(@s)
SELECT @s = ISNULL(@s+',', '')+QUOTENAME(schemaId)
FROM arschema
WHERE viewName = 'L_AL_Appending'
EXEC ('INSERT T('+@s+') VALUES(''1'',''1'',''1'')')