Joke Collection Website - News headlines - How to set the default value of sql database (how to set the default value of SQL)

How to set the default value of sql database (how to set the default value of SQL)

//The first way of writing:

MM _ conn _ STRING = " Driver = { SQL server }; Server= (local); uid = sapwd =; database = infs"

Setconn = server. (“ADODB。 Connect ")

conn.openMM_conn_STRING

SETRS = server. (“ADOBD.recordset”)

SQL = " SELECT * FROMTABLEORDERBYIDDESC "

Connecticut, 3, 3

//The second way of writing: (DSN connection)

MM _ conn _ STRING = " DSN = BBSUID = SAPWD= 12345 "

Setconn = server. (“ADODB。 Connect ")

conn.openMM_conn_STRING

SETRS = server. (“ADOBD.recordset”)

SQL = " SELECT * FROMTABLEORDERBYIDDESC "

RS.openSQL, CONN, 3,3//3,3 is the switch to modify, delete and add!

//The third way of writing:

MM _ conn _ STRING _ own = " Driver = { SQL server }; Server= (local); uid = sapwd = 1 1 1 1 1; database = infs"

Setconn = server. (“ADODB。 Connect ")

conn.openMM_conn_STRING_own

//This method is used in the fourth ACCESS.

str conn = " DRIVER = microsoftaesdriver(*。 MDB); DBQ="_

& server. MapPath("asp.mdb ")

Setconn = server. (“adodb.connection”)

conn.openstrconn