Answer Posted / ajit kumar nayak

select count(*) from syscolumns sy,Sysobjects so
where
sy.id =so.id
and so.name = <table name>

What is temporary stored procedure?

936

---

What’s the use of custom fields in report?

931

---

How to list all stored procedures in the current database using ms sql server?

1120

---

what is sql server? : Sql server database administration

975

---

How would you add a section to a table?

1023

---

Tell me what is de-normalization and what are some of the examples of it?

1010

---

How to drop an existing table with "drop table" statements in ms sql server?

1077

---

How to apply filtering criteria at group level with the having clause in ms sql server?

992

---

How do you create a clustered index?

1043

---

How is sql server used?

950

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

968

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

970

---

How many full-text indexes can a table have?

970

---

What is the standby server?

943

---

Can you please explain the difference between primary keys and foreign keys?

1099

---