SQL server 入门笔记
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) 登录后评论