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

Psudo colums

1 Answers   HP,

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

What does indexation mean?

0 Answers  

---

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,

---

---

Can you leave a union at any time?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

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

0 Answers  

---

Define left outer join in sql server joins?

0 Answers  

---