[sp]demo hàng nóng 30 char(trong hôm nay sẽ update hàng nóng này)
Code:
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11024),N'Đá Cường hóa 5' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,5) ,convert(int,5) ,convert(nvarchar(200),'strength9') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,24000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,400000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11025),N'Đá Cường hóa 6' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,6) ,convert(int,5) ,convert(nvarchar(200),'strength5') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,240000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,4000000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11026),N'Đá Cường hóa 7' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,7) ,convert(int,5) ,convert(nvarchar(200),'strength6') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,2400000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,40000000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11027),N'Đá Cường hóa 8' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,8) ,convert(int,6) ,convert(nvarchar(200),'strength7') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,24000000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,400000000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11028),N'Đá Cường hóa 9' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,9) ,convert(int,6) ,convert(nvarchar(200),'strength8') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,240000000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,1000000000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;
insert into dbo.Shop_Goods ([TemplateID],[Name],[Remark],[CategoryID],[Description],[Attack],[Defence],[Agility],[Luck],[Level],[Quality],[Pic],[MaxCount],[NeedSex],[NeedLevel],[CanStrengthen],[CanCompose],[CanDrop],[CanEquip],[CanUse],[CanDelete],[Script],[Data],[Colors],[Property1],[Property2],[Property3],[Property4],[Property5],[Property6],[Property7],[Property8],[Valid],[Count],[AddTime],[BindType],[FusionType],[FusionRate],[FusionNeedRate],[Hole],[RefineryLevel])
Values (convert(int,11029),N'Đá Cường hóa 10' ,convert(nvarchar(200),'') ,convert(int,11) ,convert(nvarchar(200),'') ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,10) ,convert(int,7) ,convert(nvarchar(200),'strength10') ,convert(int,999) ,convert(int,0) ,convert(int,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(bit,0) ,convert(bit,0) ,convert(bit,1) ,convert(nvarchar(200),'') ,convert(nvarchar(1000),'') ,convert(nvarchar(1000),'') ,convert(int,2) ,convert(int,2000000000) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,0) ,convert(int,1) ,convert(int,0) ,convert(datetime,'2011-09-12 02:11:11.000') ,convert(int,0) ,convert(int,5) ,convert(int,0) ,convert(int,2000000000) ,convert(nvarchar(50),'0,-1|0,-1|0,-1|0,-1|0,-1|0,-1') ,convert(int,-1) ) ;