存储过程中判断Select是否为空应该怎么写?
存储过程中判断Select是否为空应该怎么写?我原来用的是游标的方法,但是觉得有一些麻烦。
比如:
Declare @number_id int
Declare @Temp int
Declare employ_cursor cursor for
Select number_id From client_info Where number_id = @Temp
Open employ_cursor
Fetch next from employ_cursor
Into @Temp
Close employ_cursor
Deallocate employ_cursor
If @Temp is null
Select @number_id = 0
Else
Select @number_id = @Temp
有什么办法能直接判断Select number_id From client_info Where number_id = @Temp为NULL呢?