SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1674 Page Views: 

What is a Stored Procedure?



Posted By: Avi Date: 19 September 2009 04:11:48 AM
 Answer:

Stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of SQL statements. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance.


Posted By: eTechPlanet

Date: 19 September 2009 04:11:48 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image 4bP4Z7
Related Questions
SQL Server : The table was deleted. Now is there any way to get it back?

The table was deleted. Now is there any way to get it back?

Yes, the logs can be used to fetch the deleted table.For this one has to use some some external tool....
Category: SQL Server Date: 10/1/2010 12:02:08 PM
SQL Server : How will you currently installed service pack of the SQL Server?

How will you currently installed service pack of the SQL Server?

With the help of @@version one can determine the Service pack installed on th SQL Server. For this y....
Category: SQL Server Date: 10/1/2010 12:01:08 PM
SQL Server : Specify the ways which can be used to move data or databases between servers?

Specify the ways which can be used to move data or databases between servers?

Lots of options exists to move the data or databases. Depending on our requirements we can opt for t....
Category: SQL Server Date: 10/1/2010 12:00:08 PM
SQL Server : What does RAID mean ?

What does RAID mean ?

RAID is an acronym for "Redundant Array of Independent Disks". It is used to provide fault....
Category: SQL Server Date: 10/1/2010 11:59:08 AM
SQL Server : The file got corrupted . How can I retrieve the data from log files in SQL Server?

The file got corrupted . How can I retrieve the data from log files in SQL Server?

There are no specific commands or methods in SQL server to retrieve the data from the log files. Som....
Category: SQL Server Date: 10/1/2010 11:58:08 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories