在存储过程中如何判断一个临时表的内容是否不为空 ( 积分: 50 )

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #1

在存储过程中如何判断一个临时表的内容是否不为空<br>存储过程<br><br>select&nbsp;*&nbsp;into&nbsp;#temp&nbsp;from&nbsp;table&nbsp;where&nbsp;id&gt;30<br><br>if&nbsp;#temp的内容为空的话就不进行其它操作了，怎样判断呢？

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #2

if&nbsp;not&nbsp;exists(select&nbsp;top&nbsp;1&nbsp;*&nbsp;from&nbsp;#temp&nbsp&nbsp;{do}<br>else<br>&nbsp;&nbsp;{do}

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #3

我写的是if&nbsp;exists&nbsp;(select&nbsp;top&nbsp;1&nbsp;*&nbsp;from&nbsp;#temptown)<br>do<br>实际结果是记录集为空的时候还是执行其他操作，程序不会出错，但是空的记录集我不想处理了

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #4

一个空的记录集也认为是存在怎么办呢

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #5

这个语句也不行<br>if&nbsp;&nbsp;(OBJECT_ID('tempdb..#temp')&nbsp;&nbsp;&nbsp;IS&nbsp;&nbsp;&nbsp;NOT&nbsp;&nbsp;&nbsp;NULL&nbsp;&nbsp;&nbsp

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #6

if&nbsp;(select&nbsp;count(*)from&nbsp;temptown&nbsp;where&nbsp;_field&nbsp;is&nbsp;not&nbsp;null)&gt;0

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #7

还是不行

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #8

可以了，给分，结贴

 

F

fcy123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-27

• #9

呵呵，刚才看错了