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

What is Online Index Rebuild Operation?

1 Answers  


Explain what is it unwise to create wide clustered index keys?

0 Answers  


What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  


How to avoid cursors?

3 Answers   HP, CarrizalSoft Technologies,


What are the different authentication modes in sql server? How can it be changed?

0 Answers  






Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,


Are null values the same as that of zero or a blank space?

0 Answers  


How you provide security to cube? : sql server analysis services, ssas

0 Answers  


What are secondary xml indexes?

0 Answers  


How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  


If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  


Explain the new features of SQL server 2000?

1 Answers  






Categories