我的论坛主题

• 请问安装MYSQL时报错error:0

  2008-09-03 08:59:22   /   MS SQL Server

  请问----------如标题？？？？？:o

  查看(34) 评论(0)

• 如何在DB2中创建视图？？急。

  2008-08-12 09:10:12   /   IBM数据库产品

  现在oracle数据库中有个视图，名字为YWFW，SQL---create or replace view ywfw asselectc.companyname 单位名称,c.companyno 单位编号 ,c.servicesstart 服务日期开始 ,c.servicesend 服务日期结束,c.linkman 联系人,c.linkmemo 备注, (select sum(logincounter) from orgdepartment d where d.companyid=c.id) as 登录次数, (select count(*) from bo_sfa2_cust where orgno=c.id) as SFA客户数量, (select count(*) from BO_SFA2_CUST_LM where orgno=c.id) as SFA联系人数量, (select count(*) from BO_SFA2_CUST_OOP where org

  查看(142) 评论(3)