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

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What is row_number function?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

Explain throw statement in sql server 2008?

0 Answers  

---

How to create dbo table in sql server?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---