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 access the inserted record of an event?

0 Answers  

---

Explain the stored procedure?

0 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

What are data resources?

0 Answers  

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

What is failover clustering overview?

0 Answers  

---

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

---

Do you know what are the steps to process a single select statement?

0 Answers  

---

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

which table keeps the locking information? : Sql server administration

0 Answers  

---