What are the stored procedures?

Question

vediappan ks · Answer

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)

Pushpendra Singh · Answer

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.

Amit Singh · Answer

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

interview

What are the stored procedures?

Can you answer this question?

3 Answers