Interested to Buy Any Domain ? << Click Here >> for more details...
SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
- 1 Answers
- 5759 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 filter index?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is identity?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
What do you understand by physical_only option in dbcc checkdb?
What is an execution plan? When would you use it? How would you view the execution plan?
What is the main purpose of having conversation group?
Using the customer, and order table in northwind database, please write a query to produce xml?
Can select statements be used on views in ms sql server?
How to create user messages with print statements in ms sql server?
What is sql server profiler trace data file?
what is the main difference between after trigger and instead trigger.
-
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)
