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

What does top operator do?

0 Answers  


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,


How many joins in sql server?

0 Answers  


write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  


Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  






What is merge statement?

0 Answers  


How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,


what is sql injection in sql server?

2 Answers   TATA,


What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,


What do you mean by authentication modes in sql server?

0 Answers  


Why use triggers?

0 Answers  


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  


Categories