Set auto increment in SQL Server

sangeun jo·2021년 11월 3일

There are no increment setting in SQL Server.
But we can set auto increment through sql query.

CREATE TABLE member(
  no int identity(1,1) primary key,  //set auto increment
  mname char(20), 
  tel char(11), 
  sex bit default 0,
  birthday date,
  email char(40),
  zip char(6), 
  address char(10), 
  pic char(255)
)

I want to write documents with Korean. But I don't have Korean keyboard in my company.

profile
코더가 아니라 개발자가 되자

0개의 댓글