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 is shared lock?

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

List the types of recovery model available in sql server?

0 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What command do we use to rename a db?

5 Answers   IBM,

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Do you know the cursor types?

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

What do you mean by authentication modes in sql server?

0 Answers  

---