asp中创建表 access数据库和sql server是不是一样啊？

[yangjiecash]

在asp中创建表 用的access数据库 语法 是不是和 sql server 中的创建表的语法一样啊？

[jzywh]

操作一样

字段的定义不一样

• 打赏
• 举报

回复 赞

[emhuangzi]

同上说法`

• 打赏
• 举报

回复 赞

[kill8108]

去持楼主的说法！！！！
多看下数SQL的书吧。

• 打赏
• 举报

回复 赞

[孟子E章]

不一样
access:
<%
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
Const adChapter = 136
Const adFileTime = 64
Const adPropVariant = 138
Const adVarNumeric = 139
Const adArray = &H2000

Dim cat
Set cat = Server.CreateObject("ADOX.Catalog")
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\new.mdb"
Dim tbl
Set tbl = Server.CreateObject("ADOX.Table")
Set cat = Server.CreateObject("ADOX.Catalog")
cat.ActiveConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\new.mdb"
tbl.Name = "MyTable"
tbl.Columns.Append "Column1", adInteger
tbl.Columns.Append "Column2", adInteger
tbl.Columns.Append "Column3", adVarWChar, 50
cat.Tables.Append tbl
%>

• 打赏
• 举报

回复 赞