Answer / s. elaiyaraja

Default is the column value used in the sql.

if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.

For example varchar columns are defined as null value for
default value.

Answer / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

What is difference between views and tables?

0 Answers  

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

What is a function? Give some example?

3 Answers  

---

explain extended properties

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

Do you know what is lock escalation?

0 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---