Groups | Blog | Home
all groups > sql server (alternate) > april 2004 >

sql server (alternate) : Scripting data in tables



Saverio Tedeschi
4/13/2004 3:47:36 PM

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],
[LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat,smallint,3>,
<Denominazione,varchar(50),"Maschietti/Bambine">,
<LimiteBassoDonne,smallint,6>, <LimiteBasso,smallint,6>,
<LimiteAltoDonne,smallint,6>, <LimiteAlto,smallint,6>)
INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione],
[LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlto])
VALUES(<CodCat,smallint,4>,
<Denominazione,varchar(50),"Giovanissimi/Giovanissime">,
<LimiteBassoDonne,smallint,7>, <LimiteBasso,smallint,7>,
<LimiteAltoDonne,smallint,7>, <LimiteAlto,smallint,7>)
)
Can you pls.point me to the right direction? TIA

from tesis-Italy

*** Sent via Developersdex http://www.developersdex.com ***
Simon Hayes
4/14/2004 4:07:10 PM

[quoted text, click to view]


http://vyaskn.tripod.com/code.htm#inserts
http://www.rac4sql.net/objectscriptr_main.asp

Simon

Saverio Tedeschi
4/15/2004 8:57:14 PM

Hi Simon,
Thank you very much for your reply; that's all I need!

from tesis-Italy

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button