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

How to find tables without indexes?

0 Answers  

---

What is instead of trigger sql server?

0 Answers  

---

How to loop through returning rows?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

---

How can sql server instances be hidden?

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

What are data files?

0 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---