SQL Server基础语法

SQL Server的基础语法其实很简单，这里我们也不说一些比较复杂的语法结构了。相关基础语法如下：

Select
SELECT "栏位" FROM "表格名";

Distinct
SELECT DISTINCT "栏位"
FROM "表格名";

Where
SELECT "栏位"
FROM "表格名"
WHERE "条件";

And/Or
SELECT "栏位"
FROM "表格名"
WHERE "简单条件"
{[AND|OR] "简单条件"}+;

In
SELECT "栏位"
FROM "表格名"
WHERE "栏位" IN ('值1', '值2', ...);

Between
SELECT "栏位"
FROM "表格名"
WHERE "栏位" BETWEEN '值1' AND '值2';

Like
SELECT "栏位"
FROM "表格名"
WHERE "栏位" LIKE {模式};

Order By
SELECT "栏位"
FROM "表格名"
[WHERE "条件"]
ORDER BY "栏位" [ASC, DESC];

Count
SELECT COUNT("栏位")
FROM "表格名";

Group By
SELECT "栏位1", SUM("栏位2")
FROM "表格名"
GROUP BY "栏位1";

Having
SELECT "栏位1", SUM("栏位2")
FROM "表格名"
GROUP BY "栏位1"
HAVING (栏位);

Create Table
CREATE TABLE "表格名"
("栏位 1" "栏位 1 资料种类",
"栏位 2" "栏位 2 资料种类",
... );

Drop Table
DROP TABLE "表格名";

Truncate Table
TRUNCATE TABLE "表格名";

Insert Into
INSERT INTO "表格名" ("栏位1", "栏位2", ...)
VALUES ("值1", "值2", ...);

Update  
UPDATE "表格名"
SET "栏位1" = [新值]
WHERE "条件";

Delete From
DELETE FROM "表格名"
WHERE "条件";

以上是一些常见的基础语法，还有一些其他的语法我们之后再分享给大家