You are currently browsing the Database Management and Programing Article weblog archives for December, 2007.
You are currently browsing the Database Management and Programing Article weblog archives for December, 2007.
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..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..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..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..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..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..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..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..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..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..