Developers generally tend to use characters such as % as a delimiter for storing data in an Oracle database. But because Oracle views the % character as a Wildcard character,
If you’ve struggled with setting static variables in MouseDown, and MouseUp commands to enable users to drag borderless windows around the screen, here’s a simpler way: If Button = False
This stored procedure retrieves all the columns of each table in every database. create procedure SP_GetAllColumnsFromAllDB/*———————————————————————- Procedure to retrieve columns of all the databases– Usage : exec SP_GetAllColumnsFromAllDB– Logic is:
Building a reusable AJAX class can help you eliminate some of the headaches when you’re starting out: Open a new file called connection.js and type the following lines in to
This algorithm converts column numbers (1-x) to Excel column names. It works for any number and does not have a limit. ‘————————————————–‘ Columns can be any number from 1 to
To retrieve the required field from the table based on the supplied condition, use the following code: Function GetQueryResults(strSql As String, Optional ReadOnly As Boolean = True) _As Recordset Dim
To run Tomcat with a security manager, you must add your own policy lines to the catalina.policy file?like when you build a SecurityManager. The catalina.policy file can be found here:
To find a SQL Server object, such as a user table, query the sysobjects system table in the local database. If the database name is unknown, use the following query:
Suppose you have imported both java.util and java.sql packages into your program and you wish to use a Date class. This would create a conflict because both the packages have