how many types of store procedre in sqlserver 2000?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dinesh sharma
Their Are Two Type Of SP
1)System SP
2)dbo (DataBase Owner) mean User Defined SP
| Is This Answer Correct ? | 4 Yes | 2 No |
What is difference between index seek vs. Index scan?
What is a collation?
What is difference between rownum and row_number?
New concepts of sql server 2005 use in your project.
How do I clean up sql server transaction log?
Why should you use or avoid select * statements?
what are the limitations of parameters in a storedprocedure
How to divide query output into multiple groups with the group by clause in ms sql server?
What is the difference between migration and upgradation in sql server?
In what version of sql server were synonyms released?
Explain the third normal form(3nf)?
What are the advantages of passing name-value pairs as parameters?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)