Can you give an example of Stored Procedure?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is the difference between char, varchar and nvarchar?
What are the steps to follow to configure SQL*Net?
In which tcp/ip port does sql server run? Can it be changed?
How many databases Microsoft SQL server provides?
Tell me about builtinadministrator?
how to get the salary in descending order with out using the keyword desc in sql
What is the purpose of a table?
Can you explain what are commit and rollback in sql?
What are pessimistic lock and optimistic lock?
How to change the password of a login name in ms sql server?
What are window functions in sql server?
Why Do you want to work in this company?