SQL server增删查改
时间: 2023-09-23 21:11:15 浏览: 42
SQL Server是一种关系型数据库管理系统,它支持常见的增删查改操作,以下是一些基本的操作示例:
1. 插入数据
```
INSERT INTO table_name(column1, column2, ...) VALUES(value1, value2, ...);
```
例如,向名为"students"的表中插入一条记录:
```
INSERT INTO students(name, age, gender) VALUES('Alice', 20, 'female');
```
2. 查询数据
```
SELECT column1, column2, ... FROM table_name WHERE condition;
```
例如,查询所有年龄大于等于18岁的学生的姓名和性别:
```
SELECT name, gender FROM students WHERE age >= 18;
```
3. 更新数据
```
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
```
例如,将名为"Bob"的学生的年龄更新为21岁:
```
UPDATE students SET age = 21 WHERE name = 'Bob';
```
4. 删除数据
```
DELETE FROM table_name WHERE condition;
```
例如,删除所有性别为女性的学生记录:
```
DELETE FROM students WHERE gender = 'female';
```