SET @SQL = 'SELECT * FROM WM_T_ZIK_CHOSEI_ZISSEKI_IF WHERE ZIGYOSYO_CD = '''+@p_strZIGYOSYO_CD+''' ' IF NOT EXISTS(@SQL) .....非要这么写吗? 这样也达到目的 SET @SQL = 'SELECT * FROM WM_T_ZIK_CHOSEI_ZISSEKI_IF WHERE ZIGYOSYO_CD = '''+@p_strZIGYOSYO_CD+''' 'exec(@SQL) if @@rowcount<0 print 'yeaa!' else print 'oh'
..............
这样就可以直接查啦
.....非要这么写吗? 这样也达到目的
SET @SQL = 'SELECT * FROM WM_T_ZIK_CHOSEI_ZISSEKI_IF WHERE ZIGYOSYO_CD = '''+@p_strZIGYOSYO_CD+''' 'exec(@SQL)
if @@rowcount<0
print 'yeaa!'
else
print 'oh'