How many types of Stored Procedures in SQL Server
Answers were Sorted based on User's Feedback
Answer / skmdali786
*User defined Stored Procedures
T-SQL Stored Procedure
CLR Stored Procedure
*System Stored Procedures
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / krupalini
Basically two types they are-:
1.User defined stored procedure
2.System store procedure
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
Answer / rana
There are two type of stored Procedure in Sql Server
DDl
DML
Is This Answer Correct ? | 4 Yes | 13 No |
What is the difference between custom web user control and a custom web server control?
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
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?
Can any body provide me the sample web application in asp.net
How do I send an email message from my ASP.NET page?
What is the difference between a default skin and a named skin?
How can I create master page in asp net?
Explain authentication levels in .net ?
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?
What is a postback url?
To call a Web service SOAP which transport protocol you use?
Can you explain architecture of your project ?