What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

How to delete duplicate rows?

0 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  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

What are the pre-defined functions in the sql server?

0 Answers  

---

Explain triggers?

0 Answers  

---

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

What is sleeping status in sql server?

0 Answers  

---