Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Permanent Table Name: PermaTable1
Values:
Question is how to execute all update commands inside the table PermaTable1?
This is my query but it does not execute the update command.
DECLARE @Query1 Nvarchar(MAX)
SET @Query1= 'SELECT Query FROM dbo.PermaTable1'
EXEC(@Query1)
Hope you can help me. Thank you.
DECLARE @Query1 nvarchar(max) = N'';
SELECT @Query1 += Query + N';' FROM dbo.PermaTable1;
PRINT @Query1; -- to see the first 8,192 characters
-- EXEC sys.sp_executesql @Query1; -- uncomment this when you trust it
But I have questions. Shouldn't those update queries have where clauses? Otherwise each one is going to overwrite all rows and basically undo all the updates that came before it. Also are these update commands really stored in the same table they affect?
