SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.tableNR1(Id int, deleted bit);


INSERT INTO dbo.tableNR1(id,deleted)
VALUES(1,1);
1 rows affected

CREATE TABLE dbo.tableNR135(Id int, deleted bit);
INSERT INTO dbo.tableNR135(id,deleted)
VALUES(1,1);
1 rows affected

SELECT 'UPDATE '+ QUOTENAME(TABLE_SCHEMA)+'.'+QUOTENAME(TABLE_NAME) +
' SET deleted = NULL 
WHERE ID =1;'
FROM   INFORMATION_SCHEMA.columns
WHERE  COLUMN_NAME = 'deleted'


(No column name)


UPDATE [dbo].[tableNR1] SET deleted = NULL 
WHERE ID =1;

UPDATE [dbo].[tableNR135] SET deleted = NULL 
WHERE ID =1;


SELECT 'UPDATE '+ QUOTENAME(SCHEMA_NAME([schema_id]))+'.'+QUOTENAME([name]) +
' SET deleted = NULL 
WHERE ID =1;'
FROM   sys.tables t
WHERE EXISTS 
(
SELECT * FROM 
sys.columns c
WHERE t.object_id = c.object_id 
AND  c.[name] = 'deleted'
);


(No column name)


UPDATE [dbo].[tableNR1] SET deleted = NULL 
WHERE ID =1;

UPDATE [dbo].[tableNR135] SET deleted = NULL 
WHERE ID =1;