Tip Bank

Question: How do you access data on a mainframe using ASP? Answer: It depends on your mainframe application. If there is a way to connect to the data via ODBC

The SQL server date function provides an easy way to calculate the number of days in a month. To calculate the total number of days in each month in SQL

The application should try to bind columns to a program variable of the same data type as the column in the result set. If the application still needs to have

All statements executed in a stored procedure, including SELECT statements, generate an “x rows affected” message. These messages are typically not needed by the application when it is executing a

In ANSI SQL, you are always in a transaction, because there is no BEGIN TRANSACTION statement. The purpose of the SET IMPLICIT_TRANSACTIONS command in SQL 7.0 is to allow T-SQL

JavaScript has both numeric and string types, and it converts between these as it encounters them in the script. It uses “+” for both numeric addition as well as string

Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below

You cannot include a comment in an output expression while working with server side scripts. For example, the first line that follows will work, but the second line will not,

To quickly establish a database connection from ASP, try using a file DSN. The DSN string should not contain spaces, either, before or after the equal sign (=). In this