Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column?  It's actually very easy to do. Today, I was needed to dump the Stored Procedure result into a temp table. Below example illustrates how this can be achieved: First let us create a stored stored…