how many types of store procedre in sqlserver 2000?

Answer Posted / prashanthi g

Types of StoredProcedures

1.Userdefined StoredProcedures
2.SystemDefined storedprocedure
3.Temporary
4.Remote
5.Extended

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What stored by the tempdb ? : sql server database administration

759


Give an example of why you would want to denormalize a database

709


Difference between report and query parameter. Why do we need different type of parameter?

740


How to defragment table indexes?

699


Why are views required in the sql server or in any other database?

710






How can you list all the table constraints in a database?

697


what are the new features in SSRS?

115


Data table as parameter in sql server?

721


How do I uninstall sql server 2014?

676


Determine how to use the inserted and deleted pseudo tables?

725


What are the types of normalization?

709


What is the Main Difference between ACCESS and SQL SERVER?

746


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

793


What is page in sql server?

685


How do indexes help, types?

718