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

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

What is user defined stored procedures?

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

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  

---

Can we call stored procedure in view in sql server?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

How to get the number of affected rows?

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---