WHAT ARE THE STORED PROCEDURES?

Sanjay Sharma

Total Post:42

Points:210
Posted by  Sanjay Sharma
 1491  View(s)
Ratings:
Rate this:
  1. Pushpendra Singh

    Post:241

    Points:1205
    What are the stored procedures?

    Stored Procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data, preserving data integrity, and improving productivity.

  1. Amit Singh

    Post:565

    Points:2825
    What are the stored procedures?

    Stored procedures are similar to UDFs (user defined function).The major difference is that UDFs can be used like any other expression within SQL statements.

    for examples:

    ALTER procedure [dbo].[ProcedureName]
    @employeeid int,
    @employeepass varchar(50)

    as
    select * from sample
    where id=@id and pass=@pass

  1. vediappan ks

    Post:3

    Points:15
    What are the stored procedures?

    stored procedure 2 types first one is with parameters(@companyId int select * from mcompany where companyid= @companyID) second one is without parameter (select * from mcompany)

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!