Question

If table is not empty then show content of the table and does not execute rest of script. How to achive this? What is the best methodology? set noexec on, or raiserror? or use Return?

感谢!

Answer 1

if exists(select top 1 NULL from <your_table_name>)
begin
  --do something if you need

  select col1, col2,... from <your_table_name>
  where <your_condition>

  --do other things if needed
end
else
  return   <-- this will stop right here and return

Answer 2

它取决于所储存程序的使用情况,但RETURN是最简单和最直截了当的解决办法。

友情链接