what's sql server? : Sql server database administration

0 Answers  

---

What is Deadlock?

4 Answers   Satyam,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

What is global temp table?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

What value could be assigned to Varchar Type?

3 Answers  

---

Can group by be used without aggregate functions?

0 Answers  

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---