Tags → Function Sql

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• 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

PositionInQuotes

The PositionInQuotes function returns true or false depending on whether the position in the string you pass into it is between a pair of apostrophes or not. Useful if you''re doing any sort of SQL statement validation etc

• Categories
  • ASP →
  • Scripts and Components →
  • Miscellaneous
• Platforms
  • Linux
• Licenses
  • Freeware

Bf.Calendars

This robust, feature packed calendar will help everyone on the team track, maintain, and communicate important dates and times. With public and private calendar entries, recurring entries, attachments, user-based permissions, and the security of bf....

• Categories
  • ASP →
  • Scripts and Components →
  • Calendars
• 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

Using GetDate Function in an SQL Statement

This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.

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

txtSQL

txtSQL (pronounced &"text-sequel&") is a class containing a variety of functions designed to mimic a database system, using only regular text files. It is object-oriented and can be looked at as sort of a framework in creating large...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • GPL

Buy and Sell

Have your visitors buy and sell through your site. In less then 5 minutes you have this complete function running at your site, It''s totally ready to go. It uses access 2000 database, dynamic dropdown boxes, ability to search products, advanced...

• Categories
  • ASP →
  • Scripts and Components →
  • E-Commerce →
  • Shopping Carts
• Platforms
  • Linux
• Licenses
  • Freeware

Easy Result Browser

This function returns an array of 3 values that makes browsing through your SQL results, or any other list of results, very easy. The navigation bar looks very similar to ones used in most sites [ &<&<6 7 8 9 10&>&...

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

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• Previous
• 1
• 2
• 3
• Next