how many types of store procedre in sqlserver 2000?
Answers were Sorted based on User's Feedback
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 |
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 |
How we can compare two database data?
What is subquery explain with example?
What is Transaction?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is subquery in sql?
What is join and name different type of joins?
How do I install sql server?
Explain what is cte (common table expression)?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to Check Whether a Global Temporary Exists in a SQL Database or not?
Explain system functions or built-in functions? What are different types of system functions?
Explain the phases a transaction has to undergo?