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 built-in function?
Explain how to maintain a fill factor in existing indexes?
What is reference section?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What command must you use to include the not null constraint after a table has already been created?
What is change data capture (cdc) in sql server 2008?
what are constraints? : Sql server database administration
what are candidate key, alternate key and composite key? : Sql server database administration
How is sql used in sql server?
what is checksum in sql server.........???
What does COMMIT command do?
Oracle (3253)
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)