Inserting value in database table in sql server 2008?

what is meaning of random are you talking about columns or Row if columns insert proper values here insert into table(column1, column2...) values (val1, val2....) if its row its does not affect on your application if you are want order in application you have to write manual code if you are want order in SQL server you can set order as you want if you are want order number in auto number field so it will come in order if you does not delete any row if you are delete any row it will never repeat in auto - number field...

To store the value in a specific order you need to create a identity column in the table and while retrieving the data use order by on the identity column.

Have you defined a primary key, autonumber and/or indexes against the table? Without using one, there's no implicit ordering of rows within a table. With one or more such existing, the optimizer may or may not select one to use depending on what it judges will be the most efficient. In any case, there's no way to accurately predict the order of resultset rows without an explicit ORDER BY.