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
What does man by sql wildcard characters in sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
what are the Prerequisites for Replication?
What is use of except clause? How does it differ from not in clause?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Explain features and concepts of analysis services?
Tell me what is normalization? Explain different forms of normalization?
What is temporary table in sql server? Why we use temp table?
Why are you getting errors when creating a new odbc dsn?
What is molap and its advantage? : sql server analysis services, ssas
What is index fragmentation in ms sql server?
What is the difference in accessing db between sql server vs sql azure?
Explain the steps to use transact-sql cursor?
What is report snapshot in ssrs?
How will you go about resolving deadlocks?