Can you give an example of Stored Procedure?

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

More SQL Server Interview Questions

What is the difference between char, varchar and nvarchar?

0 Answers  


What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,


In which tcp/ip port does sql server run? Can it be changed?

0 Answers  


How many databases Microsoft SQL server provides?

0 Answers   Abacus,


Tell me about builtinadministrator?

0 Answers  






how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,


What is the purpose of a table?

0 Answers  


Can you explain what are commit and rollback in sql?

0 Answers  


What are pessimistic lock and optimistic lock?

0 Answers  


How to change the password of a login name in ms sql server?

0 Answers  


What are window functions in sql server?

0 Answers  


Why Do you want to work in this company?

4 Answers   HCL,


Categories