Archive for May, 2008

SQL entry basis: registration server

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  In SQL Server can be used in the registration wizard and registered the properties dialog two ways to register servers.    The registration process is as follows:  ... Read more..

SQL entry basis: common database objects

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  Database object database is an integral part of common as follows:    3.3.1 table (Table)    A table in the database used in our daily lives ... Read more..

Impersonation windows XP left of the menu effect

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  Introduction: Click on the menu bar, there will be smooth XP-style menu animation, the script for - IE5 + and Mozilla / Firefox.    By adding the following ... Read more..

Comprehensive engagement SQL syntax 6

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  SQL database maintenance forms and the establishment of the basic grammar of SQL made some introduction, but most of the data is biased in favour of the database queries ... Read more..

Sql string check whether there is a single conversion.

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

<%   rem string sql check whether there are single, there is a transformation    function CheckStr (str)    dim tstr, l, i, ch    l ... Read more..

Table simultaneous update of the flip-flop

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  1sql server 2000 flip-flop, table the issue of simultaneous update    2 There are three tables, A, B, C    3A, B contained in the table: A1, ... Read more..

Sql table data operation

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  Table data operations, including data insert, modify and delete.    First, insert the data in the table to add the data should note two points: first, user privileges, the ... Read more..

SQL log reduction of three methods

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  The first assumption test2 name for the database in the implementation of the query analyzer:    "400" border = "1" cellspacing = "0" cellpadding = "2" bordercolorlight = ... Read more..

Methods of data paging new ideas, very quickly

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  This article is intended to achieve, and large data tabbed browsing and optimize speed.    The establishment of a web application, the tabbed browsing is essential; this issue has ... Read more..

Transformation and conversion Attention SQL

Saturday, May 31st, 2008 Posted in DATABASE BASIC | No Comments »

  The use of data conversion services (DTS) change or conversion purpose of heterogeneous data and data between the server before, consider the different procedures to provide procedures and driver ... Read more..