Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

How to count the number of duplicate items in a table?

3 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What is the definition for sql server 2000?

0 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

Difference between Function and Procedure-in general?

6 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---