sqlserver随意记录

记录新增自增id

记录表创建

alter table stone_data_last_record add  id bigint IDENTITY (1,1) PRIMARY KEY ;



CREATE TABLE [dbo].[stone_data_before_record] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [created_at] datetime DEFAULT (getdate()) NULL,
  [data_type_id] bigint  NULL,
  [value_int] int  NULL,
  [value_float] float(53)  NULL,
  [value_string] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime DEFAULT (getdate()) NULL,
  CONSTRAINT [PK__data__3213E83926A_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)  
ON [PRIMARY]
GO

ALTER TABLE [dbo].[stone_data_before_record] SET (LOCK_ESCALATION = TABLE)
GO