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 is change data capture (cdc) feature?

0 Answers  

---

Some queries related to SQL

0 Answers   Motorola,

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

---

Define the term DML, DDL and DTL?

1 Answers  

---

What is bcnf normalization form?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---