当然可以,以下是一些常见的 SQL Server 语句示例:
1. **创建数据库**
CREATE DATABASE YourDatabaseName;
2. **删除数据库**
DROP DATABASE YourDatabaseName;
3. **创建表**
CREATE TABLE YourTableName ( ID INT PRIMARY KEY, Name NVARCHAR(50), Age INT );
4. **插入数据**
INSERT INTO YourTableName (ID, Name, Age) VALUES (1, 'John', 25);
5. **查询数据**
SELECT * FROM YourTableName;
6. **更新数据**
UPDATE YourTableName SET Age = 26 WHERE ID = 1;
7. **删除数据**
DELETE FROM YourTableName WHERE ID = 1;
8. **创建索引** (提高查询性能)
CREATE INDEX idx_name ON YourTableName (Name);
9. **创建视图** (基于一个或多个表的虚拟表)
CREATE VIEW YourViewName AS SELECT Name, Age FROM YourTableName WHERE Age > 20;
10. **删除视图**
DROP VIEW YourViewName;
11. **创建存储过程** (一组 SQL 语句的集合)
CREATE PROCEDURE GetEmployee @ID INT AS SELECT * FROM YourTableName WHERE ID = @ID;
12. **删除存储过程**
DROP PROCEDURE GetEmployee;
13. **设置权限** (例如,给某个用户对某个表的查询权限)
GRANT SELECT ON YourTableName TO [YourUserName];
14. **修改数据类型** (例如,将 Name 列的数据类型从 NVARCHAR(50) 更改为 NVARCHAR(100)):
ALTER TABLE YourTableName ALTER COLUMN Name NVARCHAR(100);