create database active
on
(name='arch1',
filename='c:\program files\microsoft sql server\mssql\data\archda1_data.mdf',
size=5,
maxsize=50,
filegrowth=1
)
log on
(name='archlog1',
filename='c:\program files\microsoft sql server\mssql\data\archlog1_log.ldf',
size=5,
maxsize=50,
filegrowth=1
)
go
解决方案 »
- select * into tbExcel1 from OPENROWSET插入出现错误。
- 取字符function,高手帮忙
- 这个sql怎么写??/急
- 求助,SQL语句
- 为什么服务器名不能用IP和域名呢,我想实现远程数据库同步??????
- pbvm70.dll 报错
- 多個字段中只要其中一個滿足條件,就篩選出來,這個語句怎麼寫?謝謝大家!
- 一个很新潮的问题
- 如何用SQL语句将一条记录分成两条逻辑上的记录
- ServerVersion = “conn.ServerVersion”引发了“System.InvalidOperationException”类型的异常
- 大家早上好,请求帮助,先谢谢了
- SQL2000 触发器问题
(1)select cname as 课程名 ,teacher as 任课老是
from b where teacher ='刘老师';
(2) select a# as 学号,sname as 姓名 from A where sex ='女';
(3) select cname,teacher from b where b#=(select b# from ab where a#='1005')
(4) select a.sname,a.a#,b.b# from a,ab,b where b.cname='英語范讀' and b.b#=ab.b# and ab.a#=a.a# and a.sex='男'
(5)问题好像错了??
2.
(1)
select sum(期中成績)/ count(學號) as 平均分,sum(期中成績) as 總分
from 學生成績表 group by 課程號
(2)
select 學號, sum(期末成績) /count(學號) as 期末平均分,sum(期末成績) as 總分
from 學生成績表 group by 學號(3)select 課程號, sum(期末成績) /count(學號) as 期末平均分,sum(期末成績) as 總分
from 學生成績表 where (select sum(期末成績) /count(學號) from 學生成績表) >60 group by 課程號