How to enter date and time literals in ms sql server?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---

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  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

What is difference statement and preparedstatement?

0 Answers  

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---