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
All ASP scripts are processed on the server side. Therefore, you don’t need to include HTML comment tags to hide the scripts from browsers that do not support scripting, as
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
Although the Dictionary object does not have an enumerator, it does have an Items method that returns a Variant array. You can use the For…Each construct on the array: Dim