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
Mention the differences between substr and charindex in sql server.
What is difference between order by and group by?
what are acid properties? : Sql server database administration
How is SQL Azure different than SQL server?
What are the advantages to use stored procedures?
According to you what goes into making the best database administrator? : sql server database administration
Give main differences between "Truncate" and "Delete".
Explain left outer join and right outer join?
What is the difference between mysql and sql server?
State the difference between local and global temporary tables?
What are the acid properties?
Why de-normalization required?
How to list all stored procedures in the current database using ms sql server?
What are the 3 types of schema?
What is difference between after and before?