how can i allocate a unique value to a column field in sql server, if no value is inserted? 
can i set some value on filed in sql server? i dont wan t to make it identity column, because some times records may be inserted from front end. But not always, in that case the column should automatically have a unique value which dont exist in the column already.