As the title suggests, i need to create a new table call CardPool
In this table i need the following structure
CardNumber (4 digits unique number) clustered
ActiveStatus (bit) default 0
then in the table i need to have the rows from 0001 to 9999
Does anyone know the correct script to generate this?