Let's say I have created a Product Table in which Product\_No is the PRIMARY KEY.
Now when a new product is inserted in every row, the primary key column should generate any random 8 digit number value which is something like this:

```
48917232
19718291
12672554
12480288
21835819

```

Probably it is not possible to achieve it with IDENTITY or UNIQUEIDENTIFIER.

Does SQL Server have any datatype that can randomly auto generate 8 digit number with every new product insert ?