What is the difference between the following two sql
statements
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 6252Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
3 6624How 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 4804Post New 247Customer SQL Server Interview Questions
What is the purpose of & in scanf?
What is the use of 'outerjoin'?
What are the basics of local (auto) objects?
What happens on a system call?
how can the same proc be re-used and called by many jobs?
What is public or shared assemblies ?
What does angie mean?
what is angular expression?
What are the benefits of destructive testing?
What are the different ways to make a field Mandatory?
can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table
Why do we use two ground pins in the pin diagram of 8086?
What is handover?
what is the difference between dry and wet type of 132kV terminations. which one is durable
What is the difference between developer trace, system log and system trace?