What extended events?

0 Answers  

---

What is compression - row-level and page-level compression?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is ACID Property of Transaction?

10 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  

---

Will the writetext statement activate a trigger?

0 Answers  

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---