各位来解释下这2者的区别
jsyxo 2006-11-22 02:27:19 这样是不会报错的:
select * from
(SELECT RunAlarmData.ID,RunAlarmData.ChannelID,
dbo.GetChannelNodeName(RunAlarmData.ChannelID,RunAlarmData.MsgID) as NodeName
FROM RunAlarmData ) a
where NodeName Like '%枢纽中心%'
=========================
这样是要报错的:
SELECT RunAlarmData.ID,RunAlarmData.ChannelID,
dbo.GetChannelNodeName(RunAlarmData.ChannelID,RunAlarmData.MsgID) as NodeName
FROM RunAlarmData
where NodeName Like '%枢纽中心%'
哪个达人说下这两者有什么区别么?这个SQL语句在运行时怎么运行的?为什么我把结果做为一个表在执行的时候不会报错,而直接进行条件选择时会抱错?