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 does dml stand for?

942

---

What are subquery and its properties?

1036

---

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.

2381

---

What is a deadlock and what is a live lock?

990

---

What are the steps to follow to configure SQL*Net?

1025

---

Can we call stored procedure in trigger?

944

---

What is openrowset sql server?

1119

---

Can we insert data into a view?

1125

---

What is trigger explain with program?

970

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1020

---

What is the use of custom fields in report?

991

---

How to maintain a fill factor in existing indexes?

993

---

How can you check the version of sql server?

1090

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

994

---

What is an active database?

1003

---