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

How many types of objects are there?

1070

Mention what are the different types of ssrs reports?

158

What is the use of custom fields in report?

1041

What is the difference between a stored procedure and a user defined function?

1062

What are sub reports?

208

What options are available to audit login activity? : sql server security

1196

What is the use of for clause?

1162

What is sql server management studio? : sql server management studio

1121

how can you check the level of fragmentation on a table? : Sql server administration

1036

How to set database to be read_only in ms sql server?

1052

What is extent? Types of extents?

1270

Please explain what is “asynchronous” communication in sql server service broker?

979

What is sql server schema compare? How we can compare two database schemas?

1078

What is data file in computer?

1000

Describe how to use linked server?

1076