SQL Server 基础之增删查改

增删查改(CURD)总结

---

添加语句：Insert

Insert into values() :

INSERT INTO [TableName]([Column1],[Column2],..) VALUES(<Values List>)

Insert into select(exec) from :

INSERT INTO [TableName]([Column1],[Column2],..) SELECT [Column1],[Column2],... FROM [TableName]

INSERT INTO [TableName]([Column1],[Column2],..) EXEC PROCEDURE 

Select into from :

SELECT [Column1],[Column2],... INTO [NewTableName] FROM [TableName]

---

删除语句：Delete

Delete from :

DELETE <TOP(n)> FROM [TableName] WHERE ...

除了Delete关键字外，Truncate也能对表进行删除。

---

查询语句：Select

Select from :

SELECT [Column1],[Column2],... FROM [TableName] WHERE ...

---

更改语句：Update

UPDATE SET :

UPDATE [TableName] SET [Column1]=Value1,[Column2]=Value2,... WHERE ...

UPDATE SET FROM :

UPDATE [TableName1] SET [Column1]=T.Value1,[Column2]=T.Value2,... FROM [TableName2] AS T WHERE ...

---