Tags → Sql And Statement

An Easy Way Delete A Record

Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

QuickMySQL

QuickMySQL is a powerful little MySQL utility program designed for novices and professionals. Create, drop, view and update tables columns and whole databases in seconds. Features: Connect to and access any localhost database on the same server or an...

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Getting Your Quotes Right In SQL For ASP

It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedenc...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

IntrSQL

The Compsys IntrSQL product is a component that allows SQL Statements to be run against almost any database over the Internet. The SQL Statement (along with DSN, Username and Password) are entered via any standard HTML (or ASP) page and the results a...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Multiple Form Selection (Where In)

Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin Hank Greenberg. The years he played are available to...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Fun With Stored Procedures...

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as oth...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Multiple Form Selection

Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

SQL Server Manager

If your database server running Microsoft SQL Server 6.5 is somewhere on the Net, you can t use the Enterprise Manager or ISQL/w (if it is located behind a firewall, as in most cases). Its web interface presented allows you to administer SQL Server v...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

ASP Express

ASP Express allows you the extreme flexibility of an HTML text editor, while giving you the automation of a great ASP and ASP.Net text editor. Key features include: Open your files directly from your web site with built in FTP services, Treeview of A...

• Categories
  • ASP →
  • Software
• Platforms
  • Linux
• Licenses
  • Commercial License

SqlFun

SqlFun is a Java program/applet that allows you to experiment with SQL statements (hopefully) without having to install a SQL server or database program. All you need is Java and Windows ODBC (or any other database server that supports JDBC). Startin...

• Categories
  • Java →
  • Applets →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• 1
• 2
• 3
• Next