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

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  


What are the different types of locks in the database?

0 Answers  


How global temporary tables are represented and its scope?

0 Answers  


What is store procedure?

0 Answers  


What is buffer cash in sql server?

0 Answers  






as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  


Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  


How to link up the text file to a Database table?

2 Answers   Allianz,


What is 'Join' and explain its various types.

0 Answers   Genpact,


What is 4nf in normalization form?

0 Answers  


What is indexing in sql server with example?

0 Answers  


What are various ways to enhance the ssrs report?

0 Answers  


Categories