What is the datatype returned by count(*)22 23082
What is SQL Profiler what is the use of it?2 10667
What are the advantages of using views. Why do we need views when we have SPs?4 12186
How many types of cursors are there in SQL Server?5 17486
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 3670
Differences between functions and stored procedures?8 9580
Can we have more than one NULL in a column having unique constraint?12 8970
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.3 4107
please tell me the query to get details of the employee having the second largest salary11 6921
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 2528
What is SQL Profiler and the use of it?2 2812
What are SQL Jobs, please mention the use of it and how to create them.1 3133
Can you use different software’s easily? : bpo
What is the advantage of Ring network ? Compare it with ethernet
Is it possible to make the html source not viewable?
What is api example?
What is outer join in sql server joins?
If you are ever stuck in an infinite loop, how will you break out of it?
how to caluclate tds from emloyees and others
How many no of poles located in the right half of s-plane for the characteristic equation...
What are the two ways to use currency filters?
what is pre process function?
ON BSE, some shares are listed as EQ and some as BE, what does it mean?
What do nonglobal variables default to a) auto b) register c) static
What is temporary table in sql server? Why we use temp table?
What are three methods of heat transfer?