1 / 6

Store procedure in SQL

Assignment help provides the SQL queries help with advanced description

getassignmenthelp4u
Download Presentation

Store procedure in SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Store Procedure Presented by: Assignmenthelp.net

  2. Introduction • Store Procedure is an SQL query , which we save so that we can use it again and again to save our time. • It has ability to pass parameter at the time of execution and execute the result according to it. • The main benefit of using store procedure is to increase the performance rate of the database.

  3. Syntax Create Procedure Procedure-name ( It is the name of Store Procedure Input parameters , Output Parameters (If required) ) As Begin Sql statement used in the stored procedure End

  4. Example CREATE PROCEDURE teststoreprocedure AS It is the name of Store Procedure SELECT * FROM Works.Person GO Name of Database Name of table

  5. How to create PROCEDURE CREATE PROCEDURE testprod2 @name nvarchar(30) AS SELECT * FROM TestNew.dbo.person WHERE Name LIKE @name + '%' GO

  6. Reference http://www.assignmenthelp.net/assignment_help/sql-store-procedure

More Related