Answer Posted / saravanan p

select count(column_Name) from information_schema.columns
where table_name='tableName'

explain different types of backups avaialabe in sql server? : Sql server database administration

603

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

530

---

What are the main sources of data?

604

---

Why use view instead of a table?

541

---

What are the advantages of the mirroring?

586

---

---

How to create median function?

118

---

What are the different types of subquery?

623

---

What is openrowset sql server?

530

---

What is primary key, unique key, and foreign key?

550

---

Tell me about builtinadministrator?

570

---

List the different index configurations possible for a table?

524

---

how to use DTS package in 2000,2005,2008 in sql server

1463

---

How to use the inserted and deleted pseudo tables?

549

---

Can a database be shrunk to 0 bytes, if not, why?

648

---

Can we call future method from trigger?

520

---