Archive for December, 2007

How SQL Server 2005 will be moved to the 64-bit platforms (1)

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  For a fairly long time, in 64-bit platforms have been running on SQL Server database is to improve the performance and scalability of a choice, but the configuration ... Read more..

Finishing teach you how to solve the SQL Server data entry (1)

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  My current projects include a 62 million lines, more than 500 out of the table.    The data from SQL Server, they reach the table in a primary ... Read more..

Manual uninstall SQL Server 2000 database (1)

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  Cooperation in various schools to install application process, found that school's database SQL SERVER 2000 damaged the heavy equipment have taken place after the same problem, which is ... Read more..

Oracle SQL commonly used in grammar and data objects

Monday, December 31st, 2007 Posted in ORACLE | No Comments »

  1. Data Control statements (DML) of the    1.INSERT (data table to insert the phrase record)    INSERT INTO Table (1 field names, field names 2,……) ... Read more..

ORACLE Hui Gunduan management

Monday, December 31st, 2007 Posted in ORACLE | No Comments »

  Hui Gunduan management ORACLE database management has been a problem, the paper introduced by examples ORACLE Hui Gunduan the concept, usage and planning and the settlement of the ... Read more..

SQL Server easily confused in the type of data

Monday, December 31st, 2007 Posted in ORACLE | No Comments »

  (1) char, varchar, text and nchar, nvarchar, ntext    char and varchar in the length of between 1 to 8000, they char is the difference between the ... Read more..

Oracle experience skill set

Monday, December 31st, 2007 Posted in ORACLE | No Comments »

  Oracle experience a skill set.    Delete table space    DROP TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]]    2.    Delete users    DROP USER ... Read more..

SQL Server Analysis server installation (1)

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  sql server 2000 the previous version, for example, generally there is no more than 7.0 version, only the Standard Edition with the desktop version, if users do not ... Read more..

SQL Server using the index of viewing conditions (1)

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  In SQL Server, the view is a preservation of the T-SQL query.    View from the definition of SQL Server preserved, so that it can be used as ... Read more..

Access database and SQL server 2000 data among I.

Monday, December 31st, 2007 Posted in SQL SERVER | No Comments »

  This paper describes the use of SQLserver through the analyzer for the implementation of SQL statement to achieve the Access database and data among SQLserver2000 I.    ... Read more..