Answer Posted / laxmi reddy

SELECT COUNT(COLUMN_NAME) FROM ALL_TAB_COLS WHERE
TABLE_NAME=<'TABLE_NAME'>;

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

680

---

Why functions are used in sql server?

590

---

What is 5nf in normalization form?

647

---

what protocol both networks use? : Sql server database administration

629

---

How can we migrate from SQL server to SQL Azure?

102

---

---

on line cluster can we make if yes tell me the procedure

1613

---

can a database be shrunk with users active? : Sql server administration

649

---

Tell me about the approaches which you used to counter the DI problems.

868

---

How to create an inline table-valued function?

629

---

What is a non equi join?

641

---

How to delete duplicate rows in sql server?

663

---

What is bulkcopy in sql?

634

---

How to count groups returned with the group by clause in ms sql server?

647

---

What command is used to rename the database?

605

---

Can primary key be null?

602

---