2013年8月15日

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 node 阅读全文

posted @ 2013-08-15 11:08 Orz.. 阅读(278) 评论(0) 推荐(0)

导航