Answer Posted / abcd

3 types:

1. DML,
2. DDL &
3. CLR (is it right?)

How to create dbo table in sql server?

1004

---

User wants only to display only pdf as export option in report manager. How to achieve this?

269

---

Explain partitioned view?

1131

---

Which tcp/ip port does sql server run on? How can it be changed?

1081

---

how to control the amount of free space in your index pages? : Sql server database administration

1085

---

Describe and explain about SQL native client?

1157

---

What is query processing?

989

---

We need to perform what steps in the following order to work with a cursor?

1274

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119

---

What action plan is preferred if sql server is not responding?

1157

---

Delete duplicate rows without using rowid.

1586

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2455

---

What are the operating modes in which database mirroring runs?

1137

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1298

---

Which is better statement or preparedstatement?

984

---