Tags → In Function In Sql

How to use SCOPE_IDENTITY() in ASP.NET

In this code sample we will take a look at how to use SCOPE_IDENTITY() in ASP.NET. We use this function to get new ID of inserted record from SQL database. .

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Freeware

Insert Date into Access Database

When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format. When working with a date in Access always use the # delimiters in your SQL statement.

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

Boolean to SQL Query Translator

This is a function to convert a user''s query in boolean syntax (&"hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Commercial License,
  • Free for non-commercial use

Zip Code Range and Distance Calculation class

This is a PHP class to do various calculations with zip codes. It''s primary purposes are to calculate the distance between two zip codes and to extract all the zip codes that are within a range of a given zip code. All calculations are based on...

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

crackerDB

This is a very limited, barely visual database manager. Users will need to know the SQL statements to locate the necessary data within the database. A login function has been included to allow it to be published in a less-than-secure location.

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

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

Page:

• Previous
• 1
• 2