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 would we use distinct statement? What is its use?
Explain different backup plans?
How many types of attribute relationships are there? : sql server analysis services, ssas
Write an sql query for deleting duplicate rows?
What happens if you add a new index to large table?
Mention the different types of triggers?
Why use “pivot” in sql server?
What is difference between Datepart() and Datename() in SqlServer?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
what is difference between NULL and ISNULL in SQL Server 2008?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the maximum rows in sql server table?