Can you give an example of Stored Procedure?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the differences between substr and charindex in sql server.

495


What is difference between order by and group by?

556


what are acid properties? : Sql server database administration

471


How is SQL Azure different than SQL server?

91


What are the advantages to use stored procedures?

548






According to you what goes into making the best database administrator? : sql server database administration

517


Give main differences between "Truncate" and "Delete".

561


Explain left outer join and right outer join?

529


What is the difference between mysql and sql server?

452


State the difference between local and global temporary tables?

535


What are the acid properties?

529


Why de-normalization required?

550


How to list all stored procedures in the current database using ms sql server?

612


What are the 3 types of schema?

574


What is difference between after and before?

485