Interested to Buy Any Domain ? << Click Here >> for more details...
SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
- 1 Answers
- 5862 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 |
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What authentication modes does sql server support?
Explain the xml support sql server extends?
When we should use @@error?
Can we call a function that has out parameter in select statement
What is transaction server auto commit?
What is table join?
What method is used by the Command classes to execute SQL statements that return single values?
what is isolation level at dead lock?
What are user defined datatypes and when you should go for them?
What is primary key, unique key, and foreign key?
How to use "begin ... End" statement structures in ms sql server?
-
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)
