SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
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 cross join in sql server joins?
Can the query output be sorted by multiple columns in ms sql server?
what is curser.
Tell me about builtinadministrator?
What is a trigger? Why we need it?
How to add a new dsn with the odbc driver for sql server?
What is rolap and its advantage? : sql server analysis services, ssas
How to make a remote connection in a database?
What are the triggers in sql?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
List down some advantages of sql stored procedure?
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
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)