Tags → In An Sql Statement

Info-Pack.com CSV2SQL

Info-Pack.com CSV 2 SQL is a csv file to sql insert statement converter.Use it to convert your acce ss comma separated files into database insert statements. Simply provide an input file, some field names and an output file name. CSV 2 SQL will th...

• Categories
  • Tools and Utilities →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Freeware

MyPagina (pagination) class

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information...

• Categories
  • PHP →
  • Scripts and Programs →
  • Site Navigation
• Platforms
  • Linux,
  • Windows
• Licenses
  • BSD Style

Professional Query Manager

Professional Query Manager is a grafic design grid to create or modify an SQL statement for Select query. Support for Join Tables, group query and extended criteria. This extension work with ASP and PHP pages It work like MS ACCESS with some s...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Windows,
  • Mac OSX
• Licenses
  • Freeware

Getdataarray

A function which returns an array containing data specified in an SQL statement using GetRows. Includes measures to help combat SQL injection.

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

Returning Month of Date in an SQL Table

This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a ''SELECT'' sql statement

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Linux
• Licenses
  • Freeware

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

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

Counting Records In ASP.NET

The following source code displays count of all records in a database. We will use a data command to execute an SQL statement that will return with count of records. Source code written in Visual Basic.NET can easily modify to work in an application.

• Categories
  • ASP.NET →
  • Tips and Tutorials
• 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

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