sql server数据库

汉字说的是列名，自己改下，学SQL的，这点应该看的出来啦

(1)

insert into tableName values('12478509258 ', '张伟聪', '75', '80', '82')

update tableName set 工资 = 2000 where 教师姓名 = '刘八'

delete from tableName where 教师姓名 = '赵六'

(2)

USE master;

GO

IF DB_ID (N'Sales') IS NOT NULL

DROP DATABASE Sales;

GO

-- Get the SQL Server data path

DECLARE @data_path nvarchar(256);

SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)

FROM master.sys.master_files

WHERE database_id = 1 AND file_id = 1);

-- execute the CREATE DATABASE statement

EXECUTE (CREATE DATABASE student

ON PRIMARY

( NAME = studentdata1,

FILENAME = @data_path + studentdata1.mdf,

SIZE = 5M,

MAXSIZE = 20M,

FILEGROWTH = 2M ),

FILEGROUP file1

( NAME = studentdata2,

FILENAME = @data_path + studentdata2.ndf,

SIZE = 2M,

MAXSIZE = UNLIMITED,

FILEGROWTH = 5% ),

FILEGROUP file2

( NAME = studentdata3,

FILENAME = @data_path + studentdata3.ndf,

SIZE = 2M,

MAXSIZE = 30M,

FILEGROWTH = 1M )

LOG ON

( NAME = studentlog1,

FILENAME = @data_path + studentlog1.ldf,

SIZE = 2MB,

MAXSIZE = 20MB,

FILEGROWTH = 2MB )

),

( NAME = studentlog2,

FILENAME = @data_path + studentlog2.ldf,

SIZE = 2MB,

MAXSIZE = 20MB,

FILEGROWTH = 2MB )

);

GO

(3)

SELECT * INTO newTable from tableName where 学生所属系 = '计算机系'

SELECT * FROM tableName where 学生所属系 = '计算机系' and 英语成绩

SELECT DISTINCT 学生所属系,COUNT(学生姓名) from tableName group by 学生所属系 order by 学生所属系

SELECT AVG(计算机基础) FROM tableName WHERE 学生所属系 = '经贸系'

SELECT 高数 FROM tableName where 学生所属系 = '计算机系' ORDER BY 高数 DESC

百科狗 baikegou.com