Post reply

Does any body have a script to load data to a table?

  • June 25, 2008 at 9:13 am

    #208981

    Hi All,

    I am trying to load a table I created for testing with loads of data. What I have in mind is a Table is

    CREATE TABLE [dbo].[tbTestTable](

    [ID] [int] IDENTITY(1,1),

    [FirstName] varchar(50),

    [LastName] varchar(50),

    [Country] varchar(50))

    I just want to load some data. Atleast 50,000 records. Anybody have one?

    Thanks

    Roy

    -Roy

  • June 25, 2008 at 9:58 am

    #834115

    Extracting customer data from the Adventure Works database is an idea...

  • June 25, 2008 at 10:19 am

    #834129

    What is the format of the file to load? If you control that, then you make it compatible with BULK INSERT and its easy. Otherwise, it is probably more difficult.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • June 25, 2008 at 10:22 am

    #834133

    sorry it is not clear to me,

    Are you trying to load data from a file?

    or load some random test data into your table?

  • June 25, 2008 at 10:38 am

    #834138

    Load some test data into the table. Marks idea is a good... I think I could use that.

    -Roy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply