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 |
How many types of the database links?
What are the different types of cursor?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
How to determine the service pack currently installed on SQL Server?
what is the primary use of the model database? : Sql server administration
Can you explain what is indexed view? How to create it?
Explain different types of Normalization.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
Is t sql the same as sql server?
How do you delete duplicate records in sql server?
How to encrypt data between dialogs?
How to use go command in "sqlcmd"?
How to create a dynamic cursor with the dynamic option?