types of Store procedure in Sqlserver2000?
Answers were Sorted based on User's Feedback
Answer / prabhakar
system stored procedures,
user defined stored procedures
Is This Answer Correct ? | 9 Yes | 1 No |
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 |
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 |
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is dbcontext and dbset in entity framework?
How do you update a dataset in ado.net?
what is Execute NOn Query?
29 Answers Infosys, Protech, Sars Systems, SwanSoft Technologies,
What is ado net stands for?
Is bulk insert faster than insert?
What are good ado.net object to replace to ado recordset object.
What are the differences between OLEDB and SQLClient Providers?
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
How is it possible to get 2 tables of data at a time by using data reader?
Differnce between Stored procedure and user defined functions?
17 Answers Microsoft, Symphony,