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

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

How do you identify a foreign key?

0 Answers  

What is the maximum size of sql server database?

0 Answers  

List out different types of normalizations in sql server and explain each of them?

0 Answers  

What is a derived table?

0 Answers  




Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

Explain identity in sql server?

0 Answers  

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

Why are views required in the sql server or in any other database?

0 Answers  

What are the different Topologies in which Replication can be configured?

0 Answers  

What is the difference between an index and a unique index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories