Database

AndyInUK wrote:

where id = 'GHREFC5C-GT5F-43RF-GRT4-TGREW34TGY67' and id <> '4RT467YH-RF43-45FH-78YG-54RYG6THYR43'

SELECT *
  FROM [dbo].[A]
 WHERE id = 'bla'
  AND id NOT IN (
      SELECT [id]
        FROM [dbo].[C])

I are Troll

declare @t table(username varchar(50),userid varchar(100))
insert into @t 
	select 'username1','a' union all select 'username1','b' union all
	select 'username1','c' union all select 'username1','d' union all
	select 'username2','a' union all select 'username3','b' union all
	select 'username3','c' union all select 'username3','d' union all
	select 'username4','a' union all select 'username4','b' union all
	select 'username4','c' union all select 'username5','d' union all
	select 'username6','a' union all select 'username7','b' union all
	select 'username8','c' union all select 'username8','d' 

username	userid
username1	a
username1	b
username1	c
username1	d
username2	a
username3	b
username3	c
username3	d
username4	a
username4	b
username4	c
username5	d
username6	a
username7	b
username8	c
username8	d

select username from  @t
except
select username from @t
where  userid in('b','c','d')

select t1.username from  @t t1
left join (select username from @t where  userid in('b','c','d')) x
on x.username = t1.username
where x.username is null

select username from (
select username, 

	stuff((select ',' + CAST(t2.userid as varchar(max)) from @t t2
	where t2.username = t1.username for xml path('')),1,1,'') as userids
from @t t1
group by username )X
where X.userids = 'a'

username2
username6

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.