SQL statement handbook (25) Create View

August 9th, 2008 admin Posted in DATABASE BASIC | 4 Comments »

  As of Table (Views) can be regarded as a virtual form.    It's different with the form, the form in the actual data storage, and the concept form, as in the table above is to establish a framework, which itself is not the actual data storage. 

  As the establishment…

AddThis Social Bookmark Button

msdn ʼ Ç (ù): CAtlFile:: Create; File Security and Access Rights;

August 9th, 2008 admin Posted in DATABASE BASIC | 9 Comments »

  1.CAtlFile:: Create 

  See Also 

  CAtlFile Overview | Class Members 

  Call this method to create or open a file. 

 …

AddThis Social Bookmark Button

(Reprint) database design guidelines —- Part 1 – before the database design

August 9th, 2008 admin Posted in DATABASE BASIC | 3 Comments »

  If the enterprise data needed to compare the blood of life, then the design of the database application is the most important part.    The database design of the voluminous material, university degree courses, there are specialized on.    However, as we have repeatedly emphasized,…

AddThis Social Bookmark Button

Distributed Oracle database link problems

August 9th, 2008 admin Posted in DATABASE BASIC | 2 Comments »

  Concept: 

  Examples of instance-create the database set db_name \ 

  Domain name-domain database as our host and network http address as a domain, such as: us.oracle.com 

  The overall situation of global_name-db_name.domain_name …

AddThis Social Bookmark Button

SQL Prompt – excellent tool for SQL grammar tips

August 9th, 2008 admin Posted in DATABASE BASIC | 3 Comments »

  Unintentionally from abroad were found on a blog a good tool for this, we can not wait for the recommendation of this completely free SQL Intellisense Prompt tools (http://www.red-gate.com/products/sql_prompt/index.htm) , The initial use of down, it can really enhance a certain production efficiency. …

AddThis Social Bookmark Button

12 articles Oracle parameters and parameters of paper (1)

August 9th, 2008 admin Posted in DATABASE BASIC | 5 Comments »

  Oracle parameters paper (1) 
  In oracle database, the parameters file contains all the configuration information database, it is very important.    I think that if the oracle to manage, must be the parameters and parameters are well aware of the document. …

AddThis Social Bookmark Button

Create Self-Validating Controls (zt)

August 9th, 2008 admin Posted in DATABASE BASIC | 2 Comments »

  Microsoft. NET lets you build complex applications quickly and easily, but its selection of controls does have notable gaps. Fortunately, you can address part of this deficiency yourself by building your own self-validating text input controls. 

  . NET's existing controls…

AddThis Social Bookmark Button

Html in select controls on

August 8th, 2008 admin Posted in DATABASE BASIC | 2 Comments »

  http://community.csdn.net/Expert/topic/4200/4200845.xml?temp=.105755 

  / / Delete all the selected items 
  <PUBLIC:METHOD NAME="deleted" /> 
  / / Check all items 
  <PUBLIC:METHOD NAME="selectAll"…

AddThis Social Bookmark Button

Talking about how to use ADO.NET database operation

August 8th, 2008 admin Posted in SQL SERVER | 4 Comments »

  CSDN recently reviewed in the post, many problems are found on the operational aspects of the database, most of which involves the use of DBConnection, DBCommand, DataAdapter and DataReader these libraries.    Following on the development of my experience, and we share experiences…

AddThis Social Bookmark Button

DB2 in the affairs of ID

August 8th, 2008 admin Posted in IBM DB2 | 11 Comments »

  DB2 in the affairs of ID Author: Yiming time :2005-08-12 17:39 Source: Internet Zebian: Xiaoyu Abstract: DB2 in the affairs of ID from the DB2 log records in search of the only unit identifier 

  Level: Intermediate 

  Knut Stolze …

AddThis Social Bookmark Button