types of Store procedure in Sqlserver2000?

Answer Posted / sudhakar

System SP, User SP, Temp SP

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different methods by which we can populate a dataset?

945


What is ambient transaction?

688


What is ado.net components?

685


Define isolation?

742


What is the significance of CommandBehavior.CloseConnection ?

841


Explian About DataAdapters

788


How do you find the count of records in a dataset?

684


Give an example that shows how to execute a stored procedure in ado.net?

794


Explain the architecture of ado.net?

804


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

751


What are the drawbacks of using ado.net?

716


What is a dynaset in access?

784


What is sql command in ado net?

716


If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

833


Which object holds only data and does not interact with data source?

720