Interested to Buy Any Domain ? << Click Here >> for more details...
SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
- 1 Answers
- 5831 Views
- Microsoft, I also Faced
- E-Mail Answers
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 |
What is use of dbcc commands?
What is dbcc updateusage?
what are cursors? : Sql server database administration
What is difference between rollback immediate and with no_wait during alter database?
Why we need a group by clause?
What is Cross Join and in which scenario do we use Cross Join?
Explain system functions or built-in functions? What are different types of system functions?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Tell me the phases a transaction has to undergo?
Explain user defined functions?
How to write a query with a right outer join in ms sql server?
List the various tools available for performance tuning?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
