mssql的delete用用到被delete的表的别名 

    +' delete m from '+@strDBName +'.dbo.m_device as m where not exists '
    +' (select 1 from @tmpDevice where nodeid = m.nodeid) '

上面终于面表了,怎样在mssql的delete用用到被delete的表的别名

 

如果不用别名会写成下面那么复杂

   +' delete from '+@strDBName +'.dbo.m_device where nodeid in '
   +' (select nodeid from '+@strDBName +'.dbo.m_device as m'
   +' where not exists(select 1 from @tmpDevice where nodeid = m.nodeid) )'

 

posted on 2013-08-15 11:08  Orz..  阅读(260)  评论(0)  编辑  收藏  举报

导航