How to edit identity field in sql?

     Usually the identity field does not allow the user to edit, when you right click on the table and select Edit.

     But we can edit edit this column through query. Through query we can temporary on the identity insert. Remember after edit the column you should off it, if not you cannot able to edit the identity field on other tables.

Example

SET IDENTITY_INSERT Table_Name ON

   INSERT Table_Name(IdentityColumnName, Col1,Col2) VALUES (54,value1,value2)

SET IDENTITY_INSERT Table_Name OFF