types of Store procedure in Sqlserver2000?

Question Posted / sharfuddin

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

How to create data relations?

0 Answers

What are three methods for displaying data in a syncfusion datagrid

0 Answers

What are ado.net objects?

0 Answers

How can we load multiple tables in to dataset?

0 Answers

What is meant by entity framework?

1 Answers

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers Wipro,

What are all components of ADO.Net data provider?

0 Answers

Describe the command object and its method.

0 Answers

What are the data providers used in ado.net

0 Answers

What are the classes in System.Data.Common Namespace?

0 Answers

Why is it important to close an ado.net application?

0 Answers

Differentiate between Dataset and Recordset.

2 Answers

For more ADO.NET Interview Questions Click Here