types of Store procedure in Sqlserver2000?

Question Posted / sharfuddin

4 Answers
10758 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

types of Store procedure in Sqlserver2000?..

Answer / prabhakar

system stored procedures,
user defined stored procedures

Is This Answer Correct ?

9 Yes

1 No

types of Store procedure in Sqlserver2000?..

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

types of Store procedure in Sqlserver2000?..

Answer / sudhakar

System SP, User SP, Temp SP

Is This Answer Correct ?

4 Yes

1 No

types of Store procedure in Sqlserver2000?..

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

Post New Answer

More ADO.NET Interview Questions

feature of ADO.Net

11 Answers Wipro,

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers

What is executescalar and executenonquery?

0 Answers

What DataReader class do in ADO.NET ?

0 Answers NA,

How to pass multiple tables in datasets simultaneously?

0 Answers

Difference between sqlcommand and sqlcommandbuilder?

0 Answers

How can we serialize the dataset object?

0 Answers

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?

14 Answers Ksb,

What are disadvantages of microsoft-provided data provider classes in ado.net?

0 Answers

Which method is used to sort the data in ADO.Net?

0 Answers

How does entity framework work?

0 Answers

What are the key features of ado.net?

0 Answers

For more ADO.NET Interview Questions Click Here