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 |
Working with TLogs
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are the difference between “where” and “having” clause in sql server?
Can we insert data into a view?
what are three different authentications to connect linked servers?
Explain linked server in sql?
How are the exceptions handled in sql server programming?
What is difference between standardization and normalization?
What is a natural primary key?
How many non clustered indexes there can be on table ?
What is table level trigger?
What is the use of sign function?