What is the command dbcc checkdb used for?

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 find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

What is the use of keyword with encryption.

0 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

Psudo colums

1 Answers   HP,

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

What is filtered index?

0 Answers  

---