Thursday, 26 June 2014

read only view in sql server

create view v as select eid,name from emp union select 0,'select' where 1=2

create view v as select eid,name from emp where eid>100 with check option

No comments:

Post a Comment