types of Store procedure in Sqlserver2000?
Answers were Sorted based on User's Feedback
Answer / prabhakar
system stored procedures,
user defined stored procedures
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vishesh tomar
There are three types of Stored Procedure in sql server
1. User Defined
2. System Defined
2. Temprary Stored Procedure
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / javed khan
There are different types of store procedure in sql server
2000 some of these store procedure are as folm.
1. user defined store procedure
2. Systems Store Procedure
3. Extended Store Procedure
Is This Answer Correct ? | 2 Yes | 0 No |
What are the pre-requisites for connection pooling?
Explain sqlconnection object?
Describe connection object in ado.net
Difference between DataReader and DataAdapter / DataSet and DataAdapter?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is the difference between ADO and ADO.Net?
What is different between sqlcommand object and command behavior object?
How would you connect to a database by using .NET?
Which database is the ado.net?
What is a data control clerk?
Why is ADO.NET serialization slower than ADO ?
Can we connect two dataadapters to same data source using single connection at same time?