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
Running isolated ASP applications in a separate memory space from the Web server has another advantage besides protecting other ASP applications and the Web server from failing in case the