how many types of store procedre in sqlserver 2000?

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

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  


What are the various editions of sql server 2017 that are available in the market?

0 Answers  


Explain database normalization?

0 Answers  


What is Transaction?

2 Answers  


List some major differences between triggers and stored procedures?

0 Answers  






Explain log shipping and mention its advantages.

0 Answers  


which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,


What value could be assigned to Varchar Type?

3 Answers  


What are the differences between clustered and non-clustered index?

0 Answers  


What is lock escalation? : sql server database administration

0 Answers  


Can the query output be sorted by multiple columns in ms sql server?

0 Answers  


Equi join and non equi join is possible with sql server?

0 Answers  






Categories