Types of store procedure in Sqlserver?

Answers were Sorted based on User's Feedback



Types of store procedure in Sqlserver?..

Answer / muthu kumar

1.Userdefined stored procedure
2.system stored procedure
3.extended stored procedure

Is This Answer Correct ?    10 Yes 0 No

Types of store procedure in Sqlserver?..

Answer / rahul

the types of stored proceudre are :

1. userdefined
2. system.
3. extended
4. global
5. temporary
6. Remote

Is This Answer Correct ?    5 Yes 3 No

Types of store procedure in Sqlserver?..

Answer / prabhakar pandey

1:user defined stored procedure
2:system defined stored procedure
3:temporary stored procedure
4:automatic stored procedure

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

when the threads are used in dot net.

2 Answers  


You are using the try? catch block seen in the following code segment, but no exceptions are ever caught by the catch block. What is the problem? SqlConnection cn =new sqlConnection(strSQL); SqlDataSet ds; try { cn.open(); //perform the data processing steps ??.. } catch (OleDbException e) { ?.. } a) The exception class is wrong; it should be sqlErrors. b) The exception class is wrong; it should be sqlSyntaxExceptios. c) The exception class is wrong; it should be sqlExceptions. d) The exception class is wrong; it should be sqlExcptions.

2 Answers   Microsoft, Syntax Softtech,


Who will magage un-managed code?

7 Answers   HP,


How does cookies work in asp net?

0 Answers  


What are the new features added from ASP to ASP.NET?

0 Answers   Amdocs,






What are web server controls in asp.net?

0 Answers  


What is the difference between Hash table and Array list?

0 Answers  


Who is using asp.net?

0 Answers  


Do you know using sql cache invalidation?

0 Answers  


i want to develope a page for online test using asp.net with c#.net. so, how to insert the questions in the database sqlserver2000 and how to pick the questions randomly when user login for test. plz send the code for this....

3 Answers   Chaitanya, Crysalis, CTS, HCL, Sein Infotech, TCS,


How can you dynamically add user controls to a page?

0 Answers  


can i use store procedure in disconnected mode? give me answer

2 Answers  


Categories