dcsimg
Graphic Design Resources Directory: Directory of Graphics Software Tutorials and All Your Graphics and Graphic Design Needs
SEARCH SITE / SITE MAP : BOOKMARK US! : GRAPHIC DESIGNER JOBS : GRAPHICS SOFTWARE TUTORIALS : GRAPHICS SOFTWARE : : GRAPHIC DESIGN BLOG : DESIGN EDUCATION
 


 

Creative Public - Creative Graphic Design Business Resources - Graphic Design Business Resources

 All Graphic Design Resources Directory now includes Original Graphic Design Articles, Links to Hand-Picked Graphics Software Resources, Desktop Publishing (DTP) Tools, & Links to Tutorials for Image Editing Graphics Software like Adobe Photoshop or QuarXpress. And visit our most popular pages - Printing Layout Templates, Graphics Software Information, Online Design Classes, Design Schools, Graphic Design Jobs, Design & Layout Articles. If you get lost, visit our Site Map.
 

AddThis Social Bookmark Button

Search Design Schools

Zip Code:

Subject:

Degree:

Online Campus Both

home > Web Design Tutorials > Programming Tutorials > ASP Coding Tutorials > ASP AND SQL DATABASE TUTORIALS

ASP AND SQL TUTORIALS : ASP SQL DATABASE TUTORIALS

How do I deal with an apostrophe (') in a SQL statement? - The apostrophe is an illegal character in T-SQL because it is interpreted as a string delimiter. To allow a ' mark to be inserted into a database, simply double-up all occurences of the ' mark:

SQL Test
- 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.

Generate SQL Statements using easy interface - 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.


ASP 101 - Using Quotes in Your SQL Commands - SQL uses a single quote (') character to mark the beginning and end of a string. As such, using a string that contains a quote can cause errors because your database thinks the string is finished and expects SQL commands to come immediately after it.

What is wrong with 'SELECT *'? - SELECT * is inefficient, particularly when you are only using a few of the columns in the table. This is because it actually makes TWO queries to the database: before it runs your query, it has to query the system tables to determine the name and datatypes of the columns. It is much more efficient to NAME your columns in the SQL query, and this will also help in having your column names right there... so you don't have to keep flipping back and forth between ASP page and database. In addition, this will prevent ambiguous column names in your resultset (in the case where both or all tables in the JOIN statement have columns with the same name). Further still, your code can break if it relies on ordinal position, and then someone inserts a column at the top of the table (which you can do in Enterprise Manager, or by dropping / re-creating the table). This is also a strong case for always defining columns in the INSERT list.

Which is better, rs(0) or rs("column_name")? - It is marginally faster to perform recordset element lookups by ordinal position (e.g. rs(0) or rs(0).value) vs name (e.g. rs("column_name")).

How to search and replace SQL Server data in all columns of all tables, in a given database? - This is one of the common requests I see in the newsgroups. People often wonder how they could search and replace data, that is stored in their tables. While this doesn't sound like a very good thing to do, there are some genuine situations, where 'find and replace' functionality is needed. For example, spelling mistakes in the column values, or moving a database from one location to another, and wanting to replace all location specific content.


Codefix - The Apostrophe Bug - In an SQL statement text is enclosed by an apostrophe at the start and an apostrophe at the end. Consider the SQL Insert statement below.

Removing single quotes for SQL statements - One of the most common problems in submitting web forms to a database using SQL is the dreaded single quote. The database reads single quotes as part of the syntax of the SQL query and invariable produces an error.

 

AddThis Social Bookmark Button


[CaRP] php_network_getaddresses: getaddrinfo failed: Name or service not known (0)

[CaRP] XML error: SYSTEM or PUBLIC, the URI is missing at line 1 -

DESIGN DIRECTORY : PORTFOLIO FREE : GRAPHIC DESIGNER JOBS : GRAPHICS SOFTWARE TUTORIALS : GRAPHICS SOFTWARE

WRITE ARTICLES FOR US & FREE PROMOTION OF YOUR GRAPHIC DESIGN BUSINESS

We are looking for submissions of Graphic Design Tutorials and Articles from Knowledgeable Graphic Designers and Publishing Professionals. We will add a paragraph about your graphic design services (or other services as long as it is not offensive) along with your published article. We will add your contact information, including your graphic design business' website link, within this paragraph. AllGraphicDesign.com gets around 16,000 Unique Visitors every day and this could mean a nice amount of traffic being sent to your graphics business' web site (or your graphic design portfolio). Find Out More Here

 

 

Please click here to visit our sponsor

Graphic Design Menu


[CaRP] php_network_getaddresses: getaddrinfo failed: Name or service not known (0)

[CaRP] XML error: SYSTEM or PUBLIC, the URI is missing at line 1 -

BOOKMARK THIS PAGE! :: MAKE US YOUR HOMEPAGE  :: SIGN UP FOR NEWSLETTER :: ADD YOUR PORTFOLIO FREE :: DESIGNER JOBS :: FREELANCER JOBS

OUR FRIENDS -- Adobe Photoshop Tutorials -- Photoshop, Flash, 3D Studio Max Tutorials -- Web Designers & Developers --Photoshop Tutorial Man -- Tutorial Guide -- Free Webmaster Tutorials -- Web Designers -- Web Design Portfolio --AllFreelanceWork--AllFreelance--Artists Helping Children --All Creative Portfolios -- All Work at Home Ideas

All Graphic Design Resources Center is always looking for more information & resources to put into our graphics directory portal. If you have any design or dtp resources that you think would fit in well, such as graphics software links, graphics and clipart foundries, objects, filters, fonts, desktop publishing or other graphic design resources articles, templates, etc...Please email us and let us know. All Graphic Design Resources Center has been around since 1998 (originally as deezin dot com), offering desktop publishing information and graphic design resources to make your web search for graphics stuff easier. Let us know how we can make All Graphic Design site more helpful for you! All informational links are hand added by an editor. Thank you for visiting our site and don't forget to bookmark this site.

R E L A T E D . L I N K S

About Us | FAQs | Contact Us | Terms of Use | Privacy Policy

All website design, text, graphics, selection and arrangement thereof, and software are the copyrighted works of Allfreelance, © 2003 - 2016 QuinStreet, Inc.