Set auto increment in SQL Server

sangeun jo·2021년 11월 3일
0

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개의 댓글