该视图的sql语句如下:SELECT mb.MBID, m.MName, t.TName, c.CName, mb.SerialNum, mb.State, mb.DeliveryNum, CONVERT(varchar(100), mb.SendDate, 23) AS SendDate, CONVERT(varchar(100),
mb.BackDate, 23) AS BackDate, mb.Re
FROM dbo.MachineBroken AS mb INNER JOIN
dbo.Machine AS m ON mb.MBID = m.MID INNER JOIN
dbo.Type AS t ON m.TID = t.TID INNER JOIN
dbo.Class AS c ON t.CID = c.CID
WHERE (mb.IsBack = 0)单独运行该视图的时候没有数据显示(表中所有数据的IsBack列值都为True,该列类型为bit),但从视图中获取数据时(运行“select * from View_MachineBrokenDetail”)却有数据显示,这是什么原因呢?
mb.BackDate, 23) AS BackDate, mb.Re
FROM dbo.MachineBroken AS mb INNER JOIN
dbo.Machine AS m ON mb.MBID = m.MID INNER JOIN
dbo.Type AS t ON m.TID = t.TID INNER JOIN
dbo.Class AS c ON t.CID = c.CID
WHERE (mb.IsBack = 0)单独运行该视图的时候没有数据显示(表中所有数据的IsBack列值都为True,该列类型为bit),但从视图中获取数据时(运行“select * from View_MachineBrokenDetail”)却有数据显示,这是什么原因呢?
解决方案 »
- 库中如何一次在所以表中查询
- DAO 连接 SQL Server 时候的问题
- 各位高手帮忙参考一下这个表怎么设计。。
- 问高手几个入门级的sql存储过程问题 谢谢。。。。。。
- 两表联合查询统计列的问题。
- 在企业管理器里面restore datebase出现问题-在线等
- 怎么样利用sqlserver的漏洞?
- ALTER COLUMN的问题
- 请问在局域网中连接sql server2000时,为什么在odbc建立sql server数据源时,有的微机用管道命名协议能连通,而有的用tcp/ip协议连通,这两各协议在连接速度上有什么区别。
- 存储过程和函数有什么区别?
- 大家来帮我写个存储过程,谢谢了
- 乱码问题
ID MBID MID SerialNum State IsBack DeliveryNum SentDate BackDate Re
2 1 1 4443re 已送修 True 125441 2012/5/10 星期四 NULL ffff其他两个表都只是根据关联编号获取名称而已,我就不列出来了,谢谢!
SELECT
mb.MBID, m.MName, t.TName, c.CName, mb.SerialNum, mb.State,
mb.DeliveryNum, CONVERT(varchar(100), mb.SendDate, 23) AS SendDate,
CONVERT(varchar(100),
mb.BackDate, 23) AS BackDate, mb.Re
FROM dbo.MachineBroken AS mb INNER JOIN
dbo.Machine AS m ON mb.MBID = m.MID
INNER JOIN
dbo.Type AS t ON mb.TID = t.TID
INNER JOIN
dbo.Class AS c ON mb.CID = c.CID
WHERE (mb.IsBack = 0)try
感觉你的关联有问题,你还是一个表一个表的理清了吧
as
SELECT mb.MBID, m.MName, t.TName, c.CName, mb.SerialNum, mb.State, mb.DeliveryNum, CONVERT(varchar(100), mb.SendDate, 23) AS SendDate, CONVERT(varchar(100),
mb.BackDate, 23) AS BackDate, mb.Re
FROM (select * from MachineBroken where IsBack=0) as mb,dbo.Machine m,dbo.Type t,dbo.Class c
where mb.MBID = m.MID
and m.TID = t.TID
and t.CID = c.CID
and mb.IsBack=0