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)
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.
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
Liked By
Write Answer
What are the stored procedures?
Join MindStick Community
You have need login or register for voting of answers or question.
vediappan ks
23-Jan-2012Pushpendra Singh
09-Nov-2010Amit Singh
09-Nov-2010for examples:
ALTER procedure [dbo].[ProcedureName]
@employeeid int,
@employeepass varchar(50)
as
select * from sample
where id=@id and pass=@pass