Answer / mahmood ali

The 'Read committed' isolation is the Default isolation
level in Sql server

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

What is xml datatype?

0 Answers  

---

What is temporal data type?

0 Answers  

---

---

What is openrowset sql server?

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

What is service broker? : sql server database administration

0 Answers  

---

What is lookup override?

0 Answers   Informatica,

---

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  

---