Stored
procedure are the group of SQL statement which run all the SQL statement in a
single unit it is precompiled object if we call to stored procedure then there
is no need to compile again.
Example of
the stored procedure is given below:
Firstly we
create a table with the name emp
Then
create stored procedure:
create
procedure abc(@id int, @nm varchar(20),@s1 int)
as
insert
into emp values(@id, @nm, @s1)
return
After execute the above code we insert data into table by using the following syntax
exec
abc 6,'Abi',22000
Output:
