what is the difference between count(*) and count(1) ?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,


Which joins are sql server default?

0 Answers  


Does an index slow down updates on indexed columns?

0 Answers  


What is the difference between rank and dense_rank?

0 Answers  


what is sql server? : Sql server database administration

0 Answers  






What are “lock” hints?

0 Answers  


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  


What is the difference between index seek vs. Index scan?

0 Answers  


What is DAC? what is the use of it?

1 Answers   Wipro,


What is the downside of using udf?

0 Answers  


i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  


what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,


Categories