Scripting data in tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Saverio Tedeschi
    #1

    Scripting data in tables


    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!
    Tags: None
    • Simon Hayes
      #2
      Re: Scripting data in tables


      "Saverio Tedeschi" <tesis@tesis.or g> wrote in message
      news:407c0b96$0 $203$75868355@n ews.frii.net...[color=blue]
      >
      > 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![/color]


      http://vyaskn.tripod.com/code.htm#inserts

      http://www.rac4sql.net/objectscriptr_main.asp


      Simon


        Comment

        • Simon Hayes
          #3
          Re: Scripting data in tables


          "Saverio Tedeschi" <tesis@tesis.or g> wrote in message
          news:407c0b96$0 $203$75868355@n ews.frii.net...[color=blue]
          >
          > 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![/color]


          http://vyaskn.tripod.com/code.htm#inserts

          http://www.rac4sql.net/objectscriptr_main.asp


          Simon


            Comment

            • Saverio Tedeschi
              #4
              Re: Scripting data in tables


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

              from tesis-Italy

              *** Sent via Developersdex http://www.developersdex.com ***
              Don't just participate in USENET...get rewarded for it!

                Comment

                • Saverio Tedeschi
                  #5
                  Re: Scripting data in tables


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

                  from tesis-Italy

                  *** Sent via Developersdex http://www.developersdex.com ***
                  Don't just participate in USENET...get rewarded for it!

                    Comment

                    Previous template Next
                    Working...