Answer / chandra deo mahto

START File_name or @<File_Name>

Answer / pankaj dwivedi

xp_cmdShell 'bat file'

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---

How to override dml statements with triggers?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

What is resultset concur_updatable?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---