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 transaction server distributed transaction?
Explain what are the database objects? : SQL Server Architecture
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
Explain the various types of concurrency problem?
Is it safe to delete log files?
Diffrent types of function
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
How to create hyperlink from returned sql query ?
What the different components of Replication and what is their use?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
How many primary keys are possible in a table?
How to create a local temporary stored procedure?
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)