How many types of Stored Procedures in SQL Server

Answers were Sorted based on User's Feedback



How many types of Stored Procedures in SQL Server..

Answer / skmdali786

*User defined Stored Procedures
T-SQL Stored Procedure
CLR Stored Procedure

*System Stored Procedures

Is This Answer Correct ?    10 Yes 1 No

How many types of Stored Procedures in SQL Server..

Answer / krupalini

Basically two types they are-:
1.User defined stored procedure
2.System store procedure

Is This Answer Correct ?    7 Yes 0 No

How many types of Stored Procedures in SQL Server..

Answer / ganesh bisht

There are three types of stored procedure in sql server
1.user-defined Procedures
(a)Transact-SQL stored procedure
(b)CLR Stored Procedure.

2.System Stored Procedures

3.Extended Stored Procedures

Is This Answer Correct ?    2 Yes 0 No

How many types of Stored Procedures in SQL Server..

Answer / rana

There are two type of stored Procedure in Sql Server
DDl
DML

Is This Answer Correct ?    4 Yes 13 No

Post New Answer

More ASP.NET Interview Questions

What is the difference between custom web user control and a custom web server control?

0 Answers  


Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal

0 Answers  


If I update session state, should I lock it, too? Are concurrent accesses by multiple requests executing on multiple threads a concern with session state?

1 Answers  


Can any body provide me the sample web application in asp.net

0 Answers  


How do I send an email message from my ASP.NET page?

0 Answers  


What is the difference between a default skin and a named skin?

0 Answers   MindCracker,


How can I create master page in asp net?

0 Answers  


Explain authentication levels in .net ?

3 Answers  


If I am developing an application that must accomodate multiple security levels though secure login and my asp.net web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?

0 Answers  


What is a postback url?

0 Answers  


To call a Web service SOAP which transport protocol you use?

3 Answers   Siebel,


Can you explain architecture of your project ?

0 Answers  


Categories