How to establish the Identity property of a field in Enterprise Manager

33213321 · Post time: 2020-2-20 21:30:01

How to establish the Identity property of a field in the Enterprise Manager?

cv4bf5d65fd · Post time: 2020-4-29 00:45:01

The Identity attribute must be an integer!

cv4bf5d65fd · Post time: 2020-4-29 08:30:01

bigint, decimal, smallint, tinyint,

33213321 · Post time: 2020-4-30 17:00:01

I set up plastic surgery

hiqwolfzzh · Post time: 2020-4-30 22:30:01

Like this:

Set to int-mark set to 'yes'-mark seed '1'-mark increment '1'
^ _ ^

muyizouzhao · Post time: 2020-5-1 21:30:01

Set a field type to int
Select "Yes" in the column attribute, "Identity Seed" is 1, and "Identity Increment" is 1.

seaeva · Post time: 2020-5-26 01:30:01

Yours may be closed, open

SET IDENTITY_INSERT tablename ON

		Remember me	Forgot password?
Password			Register