Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > SQL Server > Stored Procedure


Search:
What's New - What's Hot
How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET     
Total Hits: 427  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored procedure that you will create exists in the database. If the stored procedure does not exist, the code creates a stored procedure that takes one parameter to search the Authors table based on the last name and returns the matching rows and numb...

How to Find Keywords in SQL Server Stored Procs and Functions     
Total Hits: 411  |  Today: 0Author: Tim Ford      Rating:  
Read Reviews | Write Review |  Your Rating: 

How many times have you had to troubleshoot or make changes to an existing database that is not documented properly or completely? Even need to look for a specific stored procedure that references a specific table or process? If you have intimate knowledge of the database then this may not be much of an issue for you. What happens if this database is from an external developer, a turn-key solution provider, or developed by another individual within your company? If you utilize the INFORMATIO...

HOW TO: Configure SQL Server to Store ASP.NET Session State     
Total Hits: 211  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to configure Microsoft SQL Server for ASP.NET SQL Server mode session state management....

HOW TO: Return Errors and Warnings from a SQL Server Stored Procedure in ADO.NET     
Total Hits: 1282  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to display both SQL Server errors and warnings in ADO.NET. If you raise an error that has a severity level of 10 or less, which is a warning, no exception is raised. This warning is not populated into the SqlErrorCollection. Instead you must hook into the InfoMessage event of the Connection object and handle the message there....

HOWTO: Determine Parameter Requirements for a Stored Procedure in ASP     
Total Hits: 4163  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides the ASP code necessary to programmatically determine the parameter requirements for any stored procedure. The sample code provided determines the parameter name, data type, direction, and size of all parameters in a stored procedure. The developer can use this acquired information at design time in defining the stored procedure call. The method outlined in this article uses the "Parameters.Refresh" method and the "Parameters" collection and is useful for those developers wh...

How to: Execute a Stored Procedure that Returns Rows  Version: 0.00     Price: $0.00  
Total Hits: 111  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

To execute a stored procedure that returns row, you can run a TableAdapter query that is configured to run a stored procedure (for example, CustomersTableAdapter.Fill(CustomersDataTable)).

If your application does not use TableAdapters, call the ExecuteReader method on a command object, setting its CommandType property to StoredProcedure. ("Command object" refers to the specific command for the .NET Framework Data Provider that your application is using. For example, if your application i...

Finding a SQL Server process percentage complete with dynamic management views     
Total Hits: 428  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Some tasks that are run in SQL Sever take a long time to run and it is sometimes difficult to tell whether these tasks are progressing or not. One common way of determining that status is to look at the data returned from sp_who2 or sp_lock to ensure that things are still working and the process is not hung. With SQL Server 2005 several dynamic management views have been added, so let's take a look at some of these and how they can assist....

How to run SQL Server stored procedures from an ASP Page     
Total Hits: 314  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to run SQL Server stored procedures and use parameters from an Active Server Pages (ASP) page. This article assumes that you are familiar with the procedure to use ActiveX Data Objects (ADO) in an ASP page. Read on to learn more!...

HOW TO: Debug an Extended Stored Procedure     
Total Hits: 2695  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to properly debug an extended stored procedure....



Disclaimer - Privacy
© 2002-2017 DevASP.net