SQL server 入门笔记

Posted on 2021-04-21 10:09:13
Author: 可乐小可爱メ
INSERT INTO "tiankele"."dbo"."user" ( "name", "sex", "age") VALUES ( 'zhaoxiaoqi', 2, 28);

alter table [tiankele].[dbo].[user] add id int identity(1,1) not NULL;

DELETE FROM "tiankele"."dbo"."user" ;

CREATE TABLE "user" (
"uid" BIGINT identity(1,1) primary key not null,
"name" VARCHAR(50) NOT NULL,
"sex" INT NOT NULL,
"age" INT NOT NULL
);

SELECT * FROM "tiankele"."dbo"."user" WHERE sex = 1 ORDER BY "uid" DESC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY;


当前评论 (0) 登录后评论

暂无评论