|
|
| SQL [+] Favor-It | |
| |
 |
| | Sort By:
|
This has got to be the most-often asked question in all ASP forums. The apostrophe is an illegal character in SQL because it is interpreted as a string delimiter... Author: ASPFAQ Code: ASP 3.0 & VBScript |
For every web database project I work on, I pop this code somewhere onto the server. This page allows me to test out SQL queries before I put them into my ASP code. Author: Geno Timlin Code: ASP 2.0 & VBScript |
Make a simple interface to generate SQL Statements which can be copied and pasted into your ASP code. This is not ment to support crazy queries, or advanced SQL, but more to serve as a way to speed up mundane coding. Author: Anthony J. Biondo Jr Code: ASP 3.0 & VBScript |
| | |
In SQL queries, strings are enclosed within a pair of single quotes. Consider the following SQL query used in an ASP program... Author: DevGuru Code: ASP 3.0 & VBScript |
The apostrophe bug can get annoying here is a very easy way to deal with it. It only involves on extra line and will save you a lot of headaches. This article is written to be understood by even the novice web programmer. Author: LoudASP Code: ASP 3.0 & VBScript |
The simple stored procedute enables directly write (append) character variable to the text file from T-SQL. Author: Antonin Foller Code: ASP 2.0 & VBScript |
This is a simple code like the ones used in portals or search engines. I Hope you will learn something from this. Code: ASP 3.0 & VBScript |
| | |
When creating a data-driven Web site, often you need to test your SQL queries before placing them in your production web site. This article shows you how to create a simple web page to use to test SQL queries.
Author: Geno Timlin Code: ASP 2.0 & VBScript |
Wouldn't it be nice to be able to view the inner workings of SQL at any point in time from the web? This tutorial shows how to query the sysprocesses table to give information on connections, statuses and processes running or sleeping on the server!
Author: Code: ASP 2.0 & VBScript |
Icon Key >
 - Recently Updated
 - Showcase Listing
|