1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how many types of store procedre in sqlserver 2000?

Question Posted / sharifuddin

Answers were Sorted based on User's Feedback



how many types of store procedre in sqlserver 2000?..

Answer / prashanthi g

Types of StoredProcedures

1.Userdefined StoredProcedures
2.SystemDefined storedprocedure
3.Temporary
4.Remote
5.Extended

Is This Answer Correct ?    4 Yes 1 No

how many types of store procedre in sqlserver 2000?..

Answer / 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

More SQL Server Interview Questions

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1 Answers  

What do you understand by the analysis services in sql server?

1 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

How raid can influence database performance?

0 Answers  

What is serializable?

1 Answers  

Explain about analysis services?

1 Answers  

What does sql server mean?

1 Answers  

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

What is the difference between local and global temporary tables?

1 Answers  

Which table keeps the locking information?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories