Explain DBCC?

0 Answers   QuestPond,

---

How to generate create function script on an existing function?

0 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

Define magic tables in sql server?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

---