00001: truncate table MegaValue
00002: 
00003: set identity_insert MegaValue on
00004: 
00005: dump transaction price with no_log
00006: 
00007: insert into MegaValue ([i], [VValue], [Contents], [ToMegaShop], [ImageURL], [Image], [LoadToMyValue])
00008:                 SELECT [i], [VValue], [Contents], [ToMegaShop], [ImageURL], [Image], [LoadToMyValue]
00009: FROM OPENROWSET('SQLOLEDB','VBNET2000';'NEW';'*******', 
00010:                'SELECT [i], [VValue], [Contents], [ToMegaShop], [ImageURL], [Image], [LoadToMyValue] 
00011: FROM [SoftHelpRu].[dbo].[MegaValue]'
00012: )AS a


Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19>  <20>  <21>  <22>  <23
Link to this page: //www.vb-net.com/wanted/my/ident.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <CHAT ME>  <ABOUT ME>  < THANKS ME>