Database

UPDATE Demo   
Set BeModified = 1 WHERE ID IN (SELECT ID FROM inserted)

UPDATE Demo 
Set BeModified = 1
FROM Demo
INNER JOIN inserted 
ON Demo.ID = inserted.ID

v1i9n6o7d wrote:

My main concern is would denying permissions on tables in back-end affect the functionality of adding, modifying, and deleting data through front-end.

Delete from tableName where [whatever condition you want to use]

DELETE FROM
{table name | view name}
[WHERE search_conditions]

Delete from tablename

Delete from Employees
where Salaries > 50000

DROP TABLE table_name

Truncate Table table_name

id	name
1	name1
10	name1
2	name2
3	name3
11	name3
4	name4

id	name
1	name1
2	name2
3	name3
4	name4

delete from tblname where id in
(
	select id 
	from(select ROW_NUMBER() over(partition by name  order by name) rn,
				Id, name from tblname)X
	where rn <> 1
)

sarang_k wrote:

delete the data from the database

Drop DataBase database_name

Mycroft Holmes wrote:

When he comes back with "I can't truncate the table", you can try explaining foreign keys