There are three types of Stored Procedure in sql server 1. User Defined

types of Store procedure in Sqlserver2000?

Question Posted / vishesh tomar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1016

Explian About DataAdapters

1032

What are the connected and disconnected modes in ado.net?

916

Explain ado.net features?

1050

Does executenonquery return a value?

955

If a table contains 20000 records. In a page at each time 100 records to be displayed.

891

Explain sqlconnection object?

1005

What are the several execute methods of ado.net?

934

Explain the two fundamental objects in ado.net?

992

What is the return type of executescalar?

1018

What DataReader class do in ADO.NET ?

1099

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

988

How to bind the controls(best practice) comboboxes to the data in the dataset?

1050

What are two types of transaction supported by ado.net?

996

What is the use of SqlCommandBuilder?

1208