Ho all SQL gurus, I've searched for samples on how to automatically
scripting SQL2000 tables to export data between databases via a sql
script. (somehing like:
INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione],
[LimiteBassoDonn e], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat, smallint,3>,
<Denominazione, varchar(50),"Ma schietti/Bambine">,
<LimiteBassoDon ne,smallint,6>, <LimiteBasso,sm allint,6>,
<LimiteAltoDonn e,smallint,6>, <LimiteAlto,sma llint,6>)
INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione],
[LimiteBassoDonn e], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat, smallint,4>,
<Denominazione, varchar(50),"Gi ovanissimi/Giovanissime">,
<LimiteBassoDon ne,smallint,7>, <LimiteBasso,sm allint,7>,
<LimiteAltoDonn e,smallint,7>, <LimiteAlto,sma llint,7>)
)
Can you pls.point me to the right direction? TIA
from tesis-Italy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!