What is the datatype returned by count(*)22 29612
What is SQL Profiler what is the use of it?2 11676
What are the advantages of using views. Why do we need views when we have SPs?4 14184
How many types of cursors are there in SQL Server?5 19672
What is the difference between the following two sql
select count(*) from
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.3 4774
Differences between functions and stored procedures?8 12063
Can we have more than one NULL in a column having unique constraint?12 11742
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.3 5178
please tell me the query to get details of the employee having the second largest salary11 9694
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.2 3529
What is SQL Profiler and the use of it?2 3662
What are SQL Jobs, please mention the use of it and how to create them.1 3713
How can we check the sql server version?
What is Pradhan Mantri Jeevan Jyoti Bima Yojana?
what is the difference between the voltage of 5 volts capacitor and and 5volts battery?
What is wrong with this statement? std::auto_ptr ptr(new char);
What is the difference between jdbc and hibernate?
What is amazon elasticache?
What are the different ways of creating thread?
What is TaskTracker?
why is jsf used for?
How do you know if your jvm is up or not?
What does console mean c#?
What is a checkpoint and When does it occur?
How many are the types of instrument cables in terms of No. of pair.
When should volatile modifier be used?