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

Explain indexing and what are the advantages of it?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

Explain Trigger with an example?

2 Answers  

---

Is null vs coalesce?

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

What are different types of database indexes?

0 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

What is a filestream?

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---