Can you give an example of Stored Procedure?

Question Posted / guest

4 Answers
9790 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can you give an example of Stored Procedure?..

Answer / guest

sp_helpdb , sp_who2, sp_renamedb are a set of system defined
stored procedures. We can also have user defined stored
procedures which can be called in similar way.

Is This Answer Correct ?

4 Yes

0 No

Can you give an example of Stored Procedure?..

Answer / ghous

user defines sp...
say i want to select some values based on parameter

create sp dbo.spname
'declare var

@parametername int
as
select * from table_name
where file_name=@parametername

Is This Answer Correct ?

4 Yes

1 No

Can you give an example of Stored Procedure?..

Answer / madhesan

create database mani

use mani

create table emp
(
empno int,
empname varchar(20),
salary int
)

select * from emp

insert into emp values(2,'hari',10000)

create procedure selectproc
as select * from emp

exec selectproc

create procedure insertproc
@no int,
@name varchar(20),
@salary int
as
insert into emp values(@no,@name,@salary)

exec insertproc1 2,'pavan',15000

create procedure insertproc1
@no int,
@name varchar(20),
@salary int
as
if @no=1
print 1
else
insert into emp values(@no,@name,@salary)
print "successfully inserted!!!"

select * from syscolumns

sp_helpdb mani

sp_help selectproc
sp_helptext selectproc

set isolation level serializable

Is This Answer Correct ?

1 Yes

0 No

Can you give an example of Stored Procedure?..

Answer / jyothi

user defines sp...
say i want to select some values based on parameter

create PROCEDURE GetEmployeeDetails
-- Add the parameters for the stored procedure here
@sno int,

-- Insert statements for procedure here

select *from emp where sno=@sno

END
GO

Is This Answer Correct ?

0 Yes

1 No

Post New Answer