Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

What is the purpose of sql profiler in sql server?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

What is the function of sql server agent windows service?

0 Answers  

---

---

What are the different acid properties?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

How can you fetch alternate records from a table?

0 Answers  

---

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

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---