The work to be done after asp Access is imported to SQL Server for upgrade.

Here is the experience of two asp upgrades. You can refer to other languages. You are welcome to discuss and Add.

1. After the database is imported, fields automatically added must be overwritten, and the length of all numeric types must be increased. It is best to use bigint.
2. All default values are lost. It mainly belongs to the numeric type and date type.
3. Change now (), time (), and date () in all SQL statements to getdate ().
4. In all SQL statements, replace datediff ('D', time1, time2) with datediff (day, time1, time2), and modify other date attributes.
5. Some true/false statements may fail to be used normally. Here, it refers to the situation where bool is expressed in the integer type, which must be changed to 1/0.
6. Cast (column as varchar) is used for the remarks type.
7. Change cursortype to 1, that is, when the database is opened, the first numeric parameter must be set to 1. Otherwise, the record may
Incomplete display. That is to say, it is generally written as Rs. Open SQL, Conn, 1.
8. Change isnull (rowname) to rowname = NULL
9.ProgramIf you have a direct judgment on Integer Variables, you also need to convert the display, such:
If RS ("ID") = 0 then
To change
If clng (RS ("ID") = 0 then