types of Store procedure in Sqlserver2000?

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

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

0 Answers  


What is dbcontext and dbset in entity framework?

0 Answers  


How do you update a dataset in ado.net?

0 Answers  


what is Execute NOn Query?

29 Answers   Infosys, Protech, Sars Systems, SwanSoft Technologies,


What is ado net stands for?

0 Answers  






Is bulk insert faster than insert?

0 Answers  


What are good ado.net object to replace to ado recordset object.

0 Answers  


What are the differences between OLEDB and SQLClient Providers?

0 Answers  


How to fetch the last inserted record in a particular table?

10 Answers   CarrizalSoft Technologies, Microsoft,


WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

2 Answers  


How is it possible to get 2 tables of data at a time by using data reader?

0 Answers  


Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,


Categories