Convert an Access database to a MSSQL case method

Http://www.aliyun.com/zixun/aggregation/11208.html ">microsoft Office Access (formerly known as Microsoft Access) is a relational database management system published by Microsoft. Combined with the Microsoft Jet Database Engine and graphical user interface features, it is one of the members of Microsoft Office.

Access can access data in Jet, Microsoft SQL Server, Oracle (Oracle software company), or any ODBC-compliant database. Skilled software designers and data analysts use it to develop applications, and some unskilled programmers and non-programmers "advanced users" can use it to develop simple applications. Although it supports some object-oriented (OO) technology, it is not a complete object-oriented development tool.

Access is also the name of another Microsoft communications program, and wants to compete with ProComm and other similar programs. But afterwards Microsoft confirmed that it was a failure plan and stopped it. After a few years they renamed their names to the database software.

Open source Web Site A lot of online, I believe that a lot of webmasters are using the build station! Site open source to solve a lot of webmaster Build station problem, "as long as you can type to build station" believe that now open source site can do this! But Open source Web site is commonly used is the ACC database, the initial use may be no problem, But after thinking about the huge amount of data, many webmasters will feel the lack of the ACC database.

How to solve it? Of course, the rich, website revenue is good can buy a commercial version, if you are buying a business version of the user, you can skip this tutorial, if you want to learn how to solve the ACC database problems then please continue to look down! There may be a lot of relevant ACC-SQL tutorials on this issue online, But for some novice, may not understand at all! Here I tidy up a bit, to a fact case for the standard! Simple to introduce how ACC conversion mssql, nonsense not much say we start!

First we create a new ACC database, open the design table to create new fields: ID, text, date, user, Panduan, userid (All right, I'm afraid readers will look confused ^_^), where ID is AutoNumber, Text is set to the field length 255, date is time Date/time, default now (), user is a note, required, Panduan number, our chosen format is yes/No | default 0, userid number, default 0, so good we save it! Name the table for AA, we double click on the AA table to open a random network inside the field to add some data! Note (AutoNumber, default field is automatically obtained, we do not need to edit, the rest of the fields according to the initial properties of our definition to write the appropriate data-write at random ^_^)

Okay, after we've identified the AA table, Save our name for index.mdb!. ACC part we have finished, next we need to write some code (what you do not understand the code?)

Create Database [index]

Go

Use [index]

Go

--[AA] (for AA table)

CREATE table Creation table [dbo]. [AA] (

[ID] integer IDENTITY (1,1) NOT NULL,

[Text] varchar (255) NULL,

[Date] datetime Default (GETDATE ()) NULL,

[user] text null,

[Panduan] Bit Default (0) NOT NULL,

[UserID] integer Default (0) null

) on [Primary]

Go

Here you will see that the following fields have null and NOT NULL, which means empty and cannot be null! Here's how I interpret the code: