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

Describe the command object and its method.

996

Explain all the classes those are used for database connections between sql server and asp.net?

996

How to creating a SqlCommand Object?

1134

What is the significance of CommandBehavior.CloseConnection ?

1160

Which is faster datareader or dataadapter?

983

Describe briefly an ADO.NET Dataset ?

1079

What does ado stand for in ado.net?

1086

How to Read, Add, Update and Delete record in Entity Framework ?

1034

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1060

What is untyped dataset?

1091

What is sqldatareader in ado.net?

913

Can we load multiple tables in a dataset?

1125

Explain what are the steps to connect to a database?

974

What is the full form of ado.net?

980

What do you know about ado.net's methods?

1105