how many types of store procedre in sqlserver 2000?

Answer Posted / dinesh sharma

Their Are Two Type Of SP
1)System SP
2)dbo (DataBase Owner) mean User Defined SP

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you insert null values in a column while inserting the data?

925


Does index speed up select statements?

754


How do you send email on SQL Server?

756


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1344


What is deploy, process and build? : sql server analysis services, ssas

746






Tell me what is difference between view and materialized view?

691


How to select some specific rows from a table in ms sql server?

757


What are indexers?

806


Explain what is analysis service repository?

708


Write a SQL queries on Self Join and Inner Join.

783


Which autogrowth database setting is good?

790


What are system databases in ms sql server?

699


What are basics of policy management?

824


What are the different types of locks in the database?

649


Explain transaction server consistency?

686