Types of store procedure in Sqlserver?
Answers were Sorted based on User's Feedback
Answer / muthu kumar
1.Userdefined stored procedure
2.system stored procedure
3.extended stored procedure
Is This Answer Correct ? | 10 Yes | 0 No |
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 |
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 |
when the threads are used in dot net.
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?
How does cookies work in asp net?
What are the new features added from ASP to ASP.NET?
What are web server controls in asp.net?
What is the difference between Hash table and Array list?
Who is using asp.net?
Do you know using sql cache invalidation?
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?
can i use store procedure in disconnected mode? give me answer