数据表的创建
CREATE TABLE tableName(
ID UNIQUEIDENTIFIER PRIMARY KEY,
StuName NVARCHAR(50) NOT NULL,
Age INT
)
数据表的修改
ALTER TABLE tableName ADD Remarks VARCHAR(50)
ALTER TABLE tableName DROP COLUMN Remarks
数据表的删除
DROP TABLE tableName
数据的新增——INSERT
INSERT INTO tableName (ID,StuName,Age) VALUES( NEWID(),'张三',12)
INSERT INTO tableName VALUES( NEWID(),'李四',12)
INSERT INTO tableName (ID,StuName) VALUES( NEWID(),'王二')
数据的删除——DELETE
DELETE FROM tableName WHERE StuName='张三'
DELETE FROM tableName
数据的查询——SELECT
SELECT * FROM tableName
SELECT * FROM tableName WHERE StuName='张三'
SELECT StuName FROM tableName
SELECT COUNT(*) FROM tableName
数据的修改——UPDATE
UPDATE tableName SET Age=15 WHERE StuName='王二'