怎样把下面用sql的建表代码 转换成 用access 的建表代码呢?
谢谢objNetConn.Execute "CREATE TABLE [dbo].[" & Temptablename & "] (" & _
" [Auto_ID] [INT] IDENTITY (1,1) NOT NULL PRIMARY KEY CLUSTERED," & _
" [P_Kdrq] [datetime] NULL," & _
"[P_Dh] [char] (17) NULL ," & _
"[P_Gysbh] [char] (6) NULL," & _
"[P_Jhc] [char] (16) NULL ," & _
"[P_No] [char] (16) NULL ," & _
"[P_Hh] [char] (7) NULL," & _
"[P_Pm] [char] (30) NULL," & _
"[P_Gg] [char] (15) NULL," & _
"[P_Dw] [char] (4) NULL," & _
"[P_Sl] [int] NULL ," & _
"[P_Dj] [money] NULL ," & _
"[P_Je] [money] NULL ," & _
"[P_Zdr] [char] (10) NULL ," & _
"[P_Bz] [char] (50) ," & _
"[P_Zt] [int] ," & _
") ON [PRIMARY]"
谢谢objNetConn.Execute "CREATE TABLE [dbo].[" & Temptablename & "] (" & _
" [Auto_ID] [INT] IDENTITY (1,1) NOT NULL PRIMARY KEY CLUSTERED," & _
" [P_Kdrq] [datetime] NULL," & _
"[P_Dh] [char] (17) NULL ," & _
"[P_Gysbh] [char] (6) NULL," & _
"[P_Jhc] [char] (16) NULL ," & _
"[P_No] [char] (16) NULL ," & _
"[P_Hh] [char] (7) NULL," & _
"[P_Pm] [char] (30) NULL," & _
"[P_Gg] [char] (15) NULL," & _
"[P_Dw] [char] (4) NULL," & _
"[P_Sl] [int] NULL ," & _
"[P_Dj] [money] NULL ," & _
"[P_Je] [money] NULL ," & _
"[P_Zdr] [char] (10) NULL ," & _
"[P_Bz] [char] (50) ," & _
"[P_Zt] [int] ," & _
") ON [PRIMARY]"
解决方案 »
- 关于给定点画曲线问题!!!
- 如何运行多线程
- 急!请教大虾,为什么dategrid中无法显示数据库中已有的记录?????????
- 数据显示问题
- 哪里有下载王国荣的三本vb的电子书?(附一)
- 一个用SQL语句,做插入操作。
- Save StdPictures (BMPs) in .GIF Format with Optional Transparency
- SourceSafe高手请进。
- 如何在TextBox编辑框中捕获键盘↑↓→←的按键输入
- 在picture box或image box中显示一张位图(.bmp),怎样使一部分显示为透明?
- [求助]怎样让工程加入Data Report ,菜单 工程 里没有添加Data Report 的呀?
- 如何用vb获得本机器的机器名称和ip地址?
其他我都可以了
那第一行的IDENTITY (1,1) 要怎么改呢?