Answer / Shubhangi

Implicit cursors are automatically created by SQL Server when a SELECT statement is used within the execution of a transaction-control construct, such as BEGIN TRANSACTION and COMMIT. Implicit cursors are closed and deallocated after each transaction.

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 many types of local tables are there in sql server?

1 Answers  

---

What are indexes in sql?

2 Answers  

---

Explain about analysis services?

1 Answers  

---

What is a performance monitor?

1 Answers  

---

Which is faster statement or preparedstatement?

1 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1 Answers  

---

Explain insert into select statement?

1 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

What is instead of trigger sql server?

1 Answers  

---

What are synonyms?

1 Answers  

---