how many types of store procedre in sqlserver 2000?

Question Posted / sharifuddin

2 Answers
5798 Views
ATI, I also Faced
E-Mail Answers

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

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers

How to disable a login name in ms sql server?

0 Answers

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers

What is index, cluster index and nonclustered index?

0 Answers

How to include date and time values in sql statements?

0 Answers

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers

How to generate random numbers with the rand() function in ms sql server?

0 Answers

what is DTS what are tasks available