Answer Posted / sathish

how can i view structure of table in sql server? tell me
that query.

Select * from information_schema.columns where table_name =
xyz

What is difference between table aliases and column aliases? Do they affect performance?

920

---

How many instances per computer are there in sql server 2000?

1018

---

What are the different types of sub-queries?

1003

---

When would you use the stored procedures or functions?

955

---

What are subqueries in sql server?

1073

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1909

---

How to check if stored procedure is running in sql server?

971

---

What are points to remember while using the fillfactor argument?

916

---

How to perform backup for certificates in sql server? : sql server security

1036

---

How will you optimize a stored procedure optimization?

968

---

Explain how to send email from sql database?

984

---

Which data type columns are the best candidates for full-text indexing?

926

---

what is create database syntax? : Sql server database administration

1059

---

Can sql server be linked with other servers like oracle?

916

---

What are policy management terms?

943

---