SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES



SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES..

Answer / durgaprasad

Create View emp_dept_vw with encryption as
select emp.empid,emp.ename,dept.deptid,dept.dname
from emp,dept where emp.deptid=dept.deptid
with check option

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Working with TLogs

0 Answers  


Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  


What are the difference between “where” and “having” clause in sql server?

0 Answers  


Can we insert data into a view?

0 Answers  


what are three different authentications to connect linked servers?

1 Answers   CitiGroup,






Explain linked server in sql?

0 Answers  


How are the exceptions handled in sql server programming?

0 Answers  


What is difference between standardization and normalization?

0 Answers  


What is a natural primary key?

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  


What is table level trigger?

0 Answers  


What is the use of sign function?

0 Answers  


Categories