22,301
社区成员




create table #s(nGoodsID numeric(10) )
CREATE NONCLUSTERED INDEX [txxfDaily_idx] ON #s
(
nGoodsID
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = off, DROP_EXISTING = OFF,
ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
STATISTICS_NORECOMPUTE =off) ON [PRIMARY]
GO
SET ANSI_WARNINGS on
insert into #s select 1
union all
select 1
drop table #s