如何判断表中是否有值

if  exists(select * from [order]) and exists(select * from testmodel) and exists(select * from customer) 
print 'yes'
else
print 'no'

 

posted @ 2013-06-08 19:03  瓜王  阅读(167)  评论(0编辑  收藏  举报