Forum Replies Created

Viewing 6 posts - 61 through 66 (of 66 total)

  • RE: Loading dummy data

    what I did as a random test was the below 🙂

    INSERT INTO randomTest

    (Name, Surname, Age)

    values

    ('John'+ DATENAME(millisecond,getdate()),'Smith' + DATENAME(millisecond,getdate()), DATENAME(millisecond,getdate())),

    ('Paul'+ DATENAME(millisecond,getdate()) ,'Foster' + DATENAME(millisecond,getdate()), DATENAME(millisecond,getdate())),

    ('Lee' + DATENAME(millisecond,getdate()),'Carey' +...

    May 13, 2011 at 5:53 am

    #1324215

  • RE: Loading dummy data

    thanks a lot this will come in handy 🙂

    May 13, 2011 at 5:36 am

    #1324207

  • RE: Loading dummy data

    thank you, so it doesn't have to be completely different values just that they are unique?

    May 13, 2011 at 4:50 am

    #1324184

  • RE: Loading dummy data

    do you have any known methods to generate a lot of random rows, I could do it through a C# app but is there a good way SQL

    May 13, 2011 at 3:32 am

    #1324144

  • RE: Select COUNT(ID) vs Select Count(0)

    That makes a lot of sense now 😀 didn't think of it like that. thank you =D

    May 9, 2011 at 4:48 pm

    #1322025

  • RE: Select COUNT(ID) vs Select Count(0)

    thank you,

    wouldn't a COUNT(*) be longer if you had a BLOB ?

    May 9, 2011 at 4:08 pm

    #1322016

Viewing 6 posts - 61 through 66 (of 66 total)