Answer / Jamal Ahmad

"MSDB Database" is another system database in SQL Server that manages various administrative and operational tasks, such as job scheduling, maintenance plans, and error logs. It stores information about SQL Agent jobs, the history of executed jobs, and related settings.

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  

---

Define self join?

1 Answers  

---

difference between Clustered index and non clustered index ?

1 Answers   Infosys,

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---

What are indexes in sql?

2 Answers  

---

Can you explain important index characteristics?

1 Answers  

---

What is dbcc updateusage?

1 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What is a trigger in sql server?

1 Answers  

---

what is isolation level at dead lock?

1 Answers   Verizon,

---

What are the types of indexing?

1 Answers  

---