590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[t_COP_OrdItem](
[fOrdNo] [varchar](50) NOT NULL,
[fSNo] [int] NOT NULL,
[fGoodsCode] [varchar](100) NOT NULL,
[fGoodsName] [nvarchar](200) NULL,
[fOrdQty] [decimal](18, 6) NOT NULL,
[fUP] [decimal](18, 6) NOT NULL,
CONSTRAINT [PK_t_COP_OrdItem] PRIMARY KEY CLUSTERED
(
[fOrdNo] ASC,
[fSNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Create INDEX idx_t_COP_OrdItem_fGoodsCode ON t_COP_OrdItem(fGoodsCode)
INSERT INTO t_COP_OrdItem(fOrdNo,fSNo,fGoodsCode,fGoodsName,fOrdQty,fUP)
SELECT 'Ord001',1,'fg001','品名',100,1
SELECT a.*
FROM dbo.t_COP_OrdItem a
WHERE a.fGoodsCode='fg001'