一.系统表 数据字典的详细信息请查SQL SERVER BOL,这里仅列出一部分. 1.1.sysservers 1.查看所有本地服务器及链接服务器 select * from master..sysservers 1.2.sysdatabases 1:查询非sa创建的所有数据库 select * from master..sysdatabases where sid not in(select sid from master..syslogins where name='sa') --或者 s
一.外连接 1.左连接 left join 或 left outer join SQL语句:select * from student left join score on student.Num=score.Stu_id; 2.右连接 right join 或 right outer join SQL语句:select * from student right join score on student.Num=score.Stu_id; 3.完全外连接 full join 或 full
创建数据表空间create tablespace stbss datafile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 100m autoextend on next 32m maxsize 2048m ---------------------------------stbss 是表空间名称D:xxxxx.dbf 是你表空间数据的存放地址和文件名称size 100m 开始是100M的大小autoextend o
表连接 1.select * from student,score --笛卡尔积 2.两个表的连接: 法1:select student.sno, sname, degree from student,score ----当查询的列名两个表中都有时要在列名前面加上'表名.' where student.sno=score.sno 法2:select cno, (select sname from student where student.sno=score.sno),degree from
create VIEW view_comment as (' as type FROM wei_comment_comment w) UNION ALL (' as type from review_comment r ) UNION ALL (' as type from institution_res_report_comment i) UNION ALL (' as type from notice_comment n) UNION ALL (' as type from first_di