Microsoft SQL Server T-SQL Snippets

snippets.sql

-- Run an Update statement for all tables that have a specific column. Set TenantId=69 in all tables that have that column.
declare @sql nvarchar(max)
set @sql = (select concat('update [', t.name, '] set TenantId=69; ') as [text()]
    from sys.columns c join sys.tables t on c.object_id = t.object_id
    where c.name = 'TenantId' for xml path(''))
print @sql
execute (@sql)

-- Disable all constrant checks temporarily for a specific table
alter table TheTableName nocheck constraint all