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 are the new features are introduced in sql server 2012 reporting services?

147

What is dml command?

930

How do I perform an unattended install of sql server 2000?

1060

List out the differences between the clustered index and non-clustered index in sql server?

987

What is transaction server consistency?

1017

What is raid? : SQL Server Architecture

1151

What are the different subsets of sql?

1524

What is attribute relationships, why we need it? : sql server analysis services, ssas

941

How to optimize stored procedure optimization?

876

Can you name a few encryption mechanisms in sql server?

926

Define candidate key, alternate key, and composite key.

906

Explain trigger and its types?

1049

What is the Control Flow in SSIS

1073

How you provide security to cube? : sql server analysis services, ssas

950

How data can be copied from one table to another table?

929