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 instead of dml trigger?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

How to receive output values from stored procedures?

0 Answers  

---

Please explain go command in sql server?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

What are alternate keys?

0 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---