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

what are the limitations of parameters in a storedprocedure

1 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

What are different replication agents and what's their purpose? : sql server replication

0 Answers  

---

Can we write trigger for view?

0 Answers  

---

How many types of objects are there?

0 Answers  

---

what is a live lock? : Sql server database administration

0 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

Does the order of columns in update statements matter?

0 Answers  

---

What is difference between after and before?

0 Answers  

---