what is meant by stored procedure

Posted on 2009-12-29
Last Modified: 2012-05-08
what is meant by stored procedure

when we go for stored procedure and what purpose we go for stored procedure

could you please give me the simple example how to call and how to execute the stored procedure in sybase

Question by:stmani2005
    LVL 26

    Accepted Solution

    stored procedures are group of sql syntax designed to do some business logic.

    here is a detatiled information about sybase stored procedure creation and usage..
    LVL 39

    Assisted Solution

    by:Pratima Pharande
    A stored procedure is a named collection of SQL statements or control-of-flow language. You can create stored procedures for commonly used functions and to increase performance.

    LVL 4

    Assisted Solution

    Let´s go...

    Example to create a stored procedure::
    create procedure pr_teste (@banco sysname) as
            select * into #t_processes from master..sysprocesses
            select * from #t_processes where dbid = db_id(@banco)
    grant execute on pr_teste to public

    Example do call the stored procedure above:
    execute pr_teste 'banco_de_dados'

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneous…
    Great sound, comfort and fit, excellent build quality, versatility, compatibility. These are just some of the many reasons for choosing a headset from Sennheiser.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now