types of Store procedure in Sqlserver2000?

Question Posted / sharfuddin

4 Answers
10771 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

What does connection string consists of ?

4 Answers Digital GlobalSoft,

What is ado data control?

0 Answers

Differnce between Stored procedure and user defined functions?

17 Answers Microsoft, Symphony,

What are the essential features of ado.net?

0 Answers

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers

How can we check that some changes have been made to dataset since it was loaded?

0 Answers

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers

What is the difference between executequery and executenonquery?

0 Answers

What is disconnected scenario in entity framework?

0 Answers

Which architecture does Datasets follow?

0 Answers

What are two important objects of ADO.Net?

0 Answers

What is bubbled event can you please explain?

0 Answers

For more ADO.NET Interview Questions Click Here