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' +...

thanks a lot this will come in handy 🙂

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

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

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

thank you,

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