CREATE TABLE [dbo].[QO_OBA_CHECK] (
[QO_NUMBER] [numeric](11, 0) NOT NULL ,
[ITEM_NO] [numeric](18, 0) NULL ,
[CHECK_ITEM] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[CHECK_STD] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[ERROR_LEVEL] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
[ERROR_FLAG] [varchar] (1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[REMARK1] [varchar] (8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [public]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [shopfloor]
GO上面是我新建表 [dbo].[QO_OBA_CHECK] 时所用的语句。运行后会出现错误提示:Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'ERROR_FLAG'.
Server: Msg 208, Level 16, State 11, Line 2
Invalid object name 'dbo.QO_OBA_CHECK'.
Server: Msg 208, Level 16, State 11, Line 2
Invalid object name 'dbo.QO_OBA_CHECK'.请帮忙!十分感谢~~
[QO_NUMBER] [numeric](11, 0) NOT NULL ,
[ITEM_NO] [numeric](18, 0) NULL ,
[CHECK_ITEM] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[CHECK_STD] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[ERROR_LEVEL] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
[ERROR_FLAG] [varchar] (1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[REMARK1] [varchar] (8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [public]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [shopfloor]
GO上面是我新建表 [dbo].[QO_OBA_CHECK] 时所用的语句。运行后会出现错误提示:Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'ERROR_FLAG'.
Server: Msg 208, Level 16, State 11, Line 2
Invalid object name 'dbo.QO_OBA_CHECK'.
Server: Msg 208, Level 16, State 11, Line 2
Invalid object name 'dbo.QO_OBA_CHECK'.请帮忙!十分感谢~~
CREATE TABLE [dbo].[QO_OBA_CHECK] (
[QO_NUMBER] [numeric](11, 0) NOT NULL ,
[ITEM_NO] [numeric](18, 0) NULL ,
[CHECK_ITEM] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[CHECK_STD] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[ERROR_LEVEL] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[ERROR_FLAG] [varchar] (1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[REMARK1] [varchar] (8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [public]
GOGRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[QO_OBA_CHECK] TO [shopfloor]
GO