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 can be used instead of trigger?

0 Answers   ADITI,

---

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

0 Answers  

---

What is repeatable read?

0 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

Can group by and orderby be used together?

0 Answers  

---

How do you create an execution plan?

0 Answers  

---

How do I view a trc file?

0 Answers  

---

Define tempdb database?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

What is the function of inner join?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---