1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the datatype returned by count(*)

Question Posted / sujatha_k

Answer Posted / sujatha_k

number data type is return.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to declare a cursor with "declare ... Cursor" in ms sql server?

574

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2035

What is the impact on other user sessions when creating indexes?

544

How can sql server instances be hidden?

528

Can we check locks in database? If so, how can we do this lock check?

531




How to use user defined functions in expressions?

554

Define tempdb database?

598

What are pessimistic lock and optimistic lock?

550

what are the reporting service components in SSRS?

118

how can you attach more than 20 ldf files in sql server

1575

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

529

What is the use of custom fields in report?

561

List out the different types of locks available in sql server?

562

What is master database? : SQL Server Architecture

535

How to loop through result set objects using odbc_fetch_row()?

471