Answer / subbu

User-defined data types can be used when several tables
must store the same type of data in a column and you must
ensure that these columns have exactly the same data type,
length, and nullability.

Explain primary key?

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Can we add an identity column to decimal datatype?

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Is it safe to delete log files?

0 Answers  

---

How to display a past time in days, hours and minutes?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

What are types of subqueries?

0 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What is query cost in sql server?

0 Answers  

---