SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
Answer Posted / 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 View All Answers
How to Insert multiple rows with a single insert statement?
What is self contained sub query?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain about unique identifier data type in sql server?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Explain the database you used in your final year project?
What is the difference between the application object and session object?
How to use go command in "sqlcmd"?
Some queries related to SQL
How to achieve Paging of records in SQL SERVER?
How to get the definition of a stored procedure back?
What are the different types of triggers in SQL SERVER?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Explain what is meant by replication of database?
What is the difference between web edition and business edition?