比如下面一个语句,在java 中应该用什么方法执行?
CREATE TABLE [dbo].[AS_COL_RELATION] (
[TAB_ID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[F_REF_NAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[S_FIELD] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[D_FIELD] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[AS_COL_RELATION] (
[TAB_ID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[F_REF_NAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[S_FIELD] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[D_FIELD] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
....
Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE COFFEES " +
"(COF_NAME VARCHAR(32), SUP_ID INTEGER, PRICE FLOAT, " +
"SALES INTEGER, TOTAL INTEGER)");
....
不用这个go
就是前面部分就可以