Learn about exact numeric (decimal) datatypes.
<decimal> – exact decimal numbers between -1038 and 1038 -1, inclusive.
<numeric> – exact decimal numbers between -1038 and 1038 -1, inclusive.
<Identity> columns use <numeric> as the underlying datatype, with exact decimal numbers of scale 0 between 1 and 1038 -1, inclusive.
When you create a replication definition for a table that contains an <identity> column, specify “identity” as the datatype for the column.
set identity_insert <table_name> on
set identity_insert <table_name> off
<Identity> columns are never updated by the update command.
If the replicate data server is Adaptive Server and a table contains an <identity> column, the maintenance user must be the owner of the table (or must be the “dbo” user or aliased to the “dbo” login name) at the replicate database in order to use the Transact-SQL® identity_insert option.