Archive for June, 2008

How to set up local area network Sybase SQL AnyWhere to C / S running »

Monday, June 30th, 2008 Posted in OTHER DB | No Comments »

  Overview: The unit is used PowerBuild a software development, back-end database engine is the use of the Sybase SQL AnyWhere 5.5 version.    The default installation of single ... Read more..

On excel, access, the contents of the database sqlserver lead to the problem »

Monday, June 30th, 2008 Posted in SQL SERVER | No Comments »

  Use SQL statements directly into more convenient, fast    1. Enquiries excel    SELECT *    FROM OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0',    'Data Source = ... Read more..

linux select function under c language usage

Monday, June 30th, 2008 Posted in DATABASE BASIC | No Comments »

  October 12    linux select function under c language usage    select (I / O multi-mechanism) Table headers # i nclude    # I nclude  ... Read more..

SELECT statement options

Monday, June 30th, 2008 Posted in DATABASE BASIC | No Comments »

  SELECT options as we refined results from an article by reading it, SELECT statement with a wide variety of various options, these options can be used to control ... Read more..

VC call the general method of storage (SQLServer Total)

Monday, June 30th, 2008 Posted in SQL SERVER | No Comments »

  ADO is here to discuss the call in storage, according to MSDN example, are generally below the call option (excerpt from MSDN):    HRESULT hr = S_OK;  ... Read more..

Oracle DBA Interview Questions By BG

Monday, June 30th, 2008 Posted in IBM DB2 | No Comments »

  Oracle DBA Interview Questions By BG    1. How many memory layers are in the shared pool?    2. How do you find out from the ... Read more..

DB2 UDB for. NET

Monday, June 30th, 2008 Posted in IBM DB2 | No Comments »

  DB2 UDB for. NET    IBM introduced the VS 2005 DB additional tool, if you DB2 database is the case, Blessed are you!    Visual Studio ... Read more..

Naming Convention

Monday, June 30th, 2008 Posted in DATABASE BASIC | No Comments »

  Remarks constant naming convention to recommend constant capital letters said.    Example    # DEFINE MAX_VALUE 10    Variable naming conventions    [Scope] TypeName  ... Read more..

jsp + tomcat + mysql + sevlet + javabean configuration process

Monday, June 30th, 2008 Posted in DATABASE BASIC | No Comments »

  Author: Crossing the Divide in 2007.    URL:    Jsp in the allocation of development environment in the process will encounter many problems for the Internet summed ... Read more..

Common SQL statement:

Monday, June 30th, 2008 Posted in DATABASE BASIC | No Comments »

  Q0. Prerequisite for creating a user []    You must have permission CREATEUSER system.    When you use CREATEUSER statements create a new user, the user's permission is ... Read more..