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 is difference between views and tables?

0 Answers  

How many ways to create table-valued functions?

0 Answers  

Can I delete event logs?

0 Answers  

What does top operator do?

0 Answers  

How to Generate a Series of Random Integers With T-SQL?

1 Answers  




Can sql server be linked with other servers like oracle?

0 Answers  

what are database files and filegroups? : Sql server database administration

0 Answers  

does physical index sort data

1 Answers  

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

How do I get to sql server configuration manager?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories