如何在同一命令中执行多条语句?
DBXP 2002-12-23 09:44:53 我用Access XP、Asp.net、C#。
下面这条语句执行不正常,我应该怎么办?
String strIns = "IF NOT EXISTS (SELECT [col1] FROM [table1] WHERE [col1] = 'hello') BEGIN INSERT INTO [table1] (col1) VALUES ( 'hello') END";
下面这条语句执行正常:
String strIns = "INSERT INTO [table1] (col1) VALUES ( 'hello')";