如何在SQL Server2000中将if ... Else与select和insert语句一起使用? [英] How to use If...Else in SQL Server2000 with select and insert statements?

问题描述

如何在带有选择和插入语句的SQL Server2000中使用If ... Else?

How to use If...Else in SQL Server2000 with select and insert statements??

推荐答案

您可以执行以下操作:

You can do something like:

IF EXISTS (SELECT 1 FROM Table_name WHERE data_field  = '')  
BEGIN    
   SELECT TableID FROM Table_name WHERE data_field = '' 
END 
ELSE 
BEGIN    
   INSERT INTO Table_name (data_field) VALUES('') 
END

这篇关于如何在SQL Server2000中将if ... Else与select和insert语句一起使用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！