sql語句系列(1)-insert、update、delete語句

建立簡單的資料表:

CREATE TABLE Student(
 StudentNo INT PRIMARY KEY IDENTITY(0,1) NOT NULL,
 StudentName VARCHAR(20) NOT NULL,
 Age SMALLINT NOT NULL,
 Address VARCHAR(200)   NULL,
 Remark VARCHAR(200) NULL
); 
           

修改資料表:

//添加檢查限制
ALTER TABLE Student
ADD CONSTRAINT CK_Student_Age CHECK(Age>=0 AND Age<=120)
//添加字段:
ALTER TABLE Student
ADD Salary MONEY NULL
           

Insert 插入語句:

INSERT INTO Customer(CustomerName,IdentityNo,Adddress,Email,Remark) 
VALUES('徐姑姑','320323198505648958','上海','[email protected]','well done!');


INSERT INTO Customer(CustomerName,IdentityNo,Adddress,Email,Remark) 
VALUES('朱閃閃','32032319880864836','蘇州','[email protected]','Come On!'),
('張大炮','32032319890845636','杭州','[email protected]','逗比一個')
           

--将查詢出來的結果集插入到資料表中
INSERT INTO Customer(CustomerName,IdentityNo,Adddress,Email,Remark) 
SELECT '王豔','3689566238466366','湖南','[email protected]','so nice a person'
           

Update語句:

UPDATE Customer SET CustomerName='王思聰',IdentityNo='356894198658564836',Adddress='北京',
Email='[email protected]',Remark='豪華富二代' WHERE CustomerNo=3
           

Delete語句: