|
|
|
|
|
Total Hits: 83 | Today: 0 |
Author: Nitin Srivastava
|
Rating:
|
|
|
User Define functions and stored procedure are looks simillar to each other, but there is lots of difference between them.
Here we are discussing the follwing arcticels.
1) What as User Defined Function.
2) Catagaries of User define function
3) What are stored procedure.
4) Basic difference between the User defined function and the stored procedures.
5) Create syntax of Stored Procedure
6) Create syntax of User Defined Function...
|
|
|
|
Total Hits: 54 | Today: 0 |
Author: Chris Garrett
|
Rating:
|
|
|
Eventually, most ASP programmers will find they need to write stored procedures because they find they are writing the same or similar SQL queries over and over in their web project or will require the performance that only a stored procedure will bring....
|
|
|
|
Total Hits: 75 | Today: 0 |
Author: Abhijeet Kumar
|
Rating:
|
|
|
Here i am presenting an exhaustive list of difference between Stored Procedures and Functions in Database.
1> Functions can be called from procedure where as procedures cannot be called from function.
2> Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
3> Function must return one and only one value where as Procedure can return any number of values (0 to n)....
|
|
|
|
Total Hits: 47 | Today: 0 |
Author: RDRaja
|
Rating:
|
|
|
Some times , we need to pass more than one integer value to query for IN Operator , normally it is not possible ,
because array parameter is taken to one string values like this...
|
|
|
|
Total Hits: 467 | Today: 0 |
Author: Steven Smith
|
Rating:
|
|
|
This article covers simply HOW to use stored procedures with ADO. WHY you should do so is covered in another article, but suffice to say that you should. SQL code in your ASP page is BAD. Remember that and you'll do fine. Now let's look at some code....
|
|
|
|
Total Hits: 365 | Today: 0 |
Author: Himanshu Khatri
|
Rating:
|
|
|
Stored procedures can offer performance gains when used instead of regular queries. This article will start with the basics and give you the complete overview on stored procedures and how to use them. Have you ever thought what happens when your queries get to the database?. They are actually compiled each time you query and then executed, but this is not the ideal approach. A much better option would be to have the database server compile the query, store it in a compiled format and run it on r...
|
|
|
|
Total Hits: 258 | Today: 0 |
Author: Randy Dyess
|
Rating:
|
|
|
An often over-looked method to help prevent SQL Injection attacks is the use of parameterized stored procedures. This first article in a two-part series briefly discusses the use of a parameterized stored procedure to help prevent SQL Injection attacks during your web site logon process....
|
|
|
|
Total Hits: 278 | Today: 0 |
Author: Chris Garrett
|
Rating:
|
|
|
Eventually, most ASP programmers will find they need to write stored procedures because they find they are writing the same or similar SQL queries over and over in their web project or will require the performance that only a stored procedure will bring....
|
|
|
|
Total Hits: 3022 | Today: 0 |
Author: Chris Hembrow
|
Rating:
|
|
|
Stored procedures are compiled SQL applications which run significantly faster than a standard query. This information describes the process of running queries built into a MS Access database, to replicate the functionality of a stored procedure....
|
|
|
|
Total Hits: 5724 | Today: 0 |
Author: Benny Alexander
|
Rating:
|
|
|
The article is indented towards ASP and VB Programmers who always write hard core SQL statements inside their coding to communicate with database.Its time to learn and switch over into Stored Procedures....
|
|
|
|
Total Hits: 1192 | Today: 0 |
Author: Abstractvb
|
Rating:
|
|
|
Just drop this code on a new ASP page, change the connection string and run it. It will create a new stored procedure called CountProducts that will count the number of Products in the table called Products....
|
|
|
|
Total Hits: 366 | Today: 0 |
Author: Brian Lockwood
|
Rating:
|
|
|
Reads SQL Stored procedure meta data to provide a complete reporting solution including user input forms for criteria and sortable, pageable html reports....
|
|
|
|
Total Hits: 1219 | Today: 1 |
|
Rating:
|
|
|
You can design stored procedures to hide complex business rules and logic, leaving a more concise interface available for application development....
|
|
|
|
Total Hits: 1919 | Today: 0 |
Author: ATM
|
Rating:
|
|
|
Here is HOWTO call access' select,insert,update and delete queries from asp....
|
|
|
|
Total Hits: 1603 | Today: 0 |
Author: Daniel Anderson
|
Rating:
|
|
|
Demonstrates how to page through a recordset using a stored procedure as opposed to client-side cursors. This approach increases performance for paging through tables that aren’t extremely large....
|
|
|
|
Total Hits: 164 | Today: 0 |
Author: John R. Lewis
|
Rating:
|
|
|
My first article on this topic ADO in your ATL component, was a very basic example of using ADO in an ATL component. This article goes a step further, and will show you how to call a Stored Procedure with parameters using the Command object....
|
|
|
|
Total Hits: 2613 | Today: 0 |
|
Rating:
|
|
|
This is the format for a stored procedure where you want to pass parameters. This is a basic reference article on the different ways you can create a stored Procedure, then pass parameters to it....
|
|
|
|
Total Hits: 3996 | Today: 0 |
|
Rating:
|
|
|
This tutorial discusses how to use stored procedures to execute non-SELECT SQL statements, and how to use the ADO Command Object to execute stored procedures through an ASP page....
|
|
|
|
Total Hits: 1332 | Today: 0 |
|
Rating:
|
|
|
This tutorial demonstrates how you can run dynamic SQL statements inside of stored procedures.Oftentimes you'd like to be able to customize a stored procedure so that a different table could be queried, based upon the passed in parameters....
|
|
|
|
Total Hits: 3064 | Today: 0 |
|
Rating:
|
|
|
Describes how to write stored procedures using SQL Server. Using stored procedures have a number of benefits, from performance gainsin the data queries to providing a layer of encapsulation between your database and ASP pages....
|
|
|
|
|
|
|
