select count(*) NoOfColumns from SYSCOLUMNS WHERE id= (Select id from SYSO

what is meant by deafult in sql server?

Question Posted / kishore

Answer Posted / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between char, varchar and nvarchar?

1026

How can sql injection be stopped? : sql server security

1044

Would you store your query in a ssrs report or a database server? State the reason why?

152

Explain the dirty pages?

1013

How to return the second 5 rows in ms sql server?

1068

Explain about nested stored procedure?

1039

What is faster join or union?

1224

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1023

What are functions in the sql server?

1225

What is fill factor and pad index?

1016

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1146

How to invoke a trigger on demand?

1096

Find first and last day of current month in sql server

1028

Define ACID properties in a Database?

1064

How to count duplicated values in a column in ms sql server?

1099