但是从语句的意义来看,似乎应该是:string sql = @"SELECT ACTIVITY.ACTIVITYID AS ""kkk"",ACTIVITY.ORGID AS ""bbbb"" FROM DB2ADMIN.ACTIVITY ACTIVITY";
我猜原文可能是VB的字符串:"SELECT ACTIVITY.ACTIVITYID AS ""kkk"",ACTIVITY.ORGID AS ""bbbb""" & Chr(13) & "" & Chr(10) & "FROM DB2ADMIN.ACTIVITY ACTIVITY"
SELECT ACTIVITY.ACTIVITYID AS ""kkk"",ACTIVITY.ORGID AS ""bbbb""" & Chr(13) & "" & Chr(10) & "FROM DB2ADMIN.ACTIVITY ACTIVITY
lz分太多了吧? string sql = "SELECT ACTIVITY.ACTIVITYID AS kkk,ACTIVITY.ORGID AS bbbb FROM DB2ADMIN.ACTIVITY ACTIVITY "; SQL中,引号是用来限定包含特殊字符的标识符的,你的SQL中可以去掉,回车换行也可以去掉,结果都是一样的
string sql = @"SELECT ACTIVITY.ACTIVITYID AS ""kkk"",ACTIVITY.ORGID AS ""bbbb"" FROM DB2ADMIN.ACTIVITY ACTIVITY";
FROM DB2ADMIN.ACTIVITY ACTIVITY";
string sql = "SELECT ACTIVITY.ACTIVITYID AS kkk,ACTIVITY.ORGID AS bbbb FROM DB2ADMIN.ACTIVITY ACTIVITY ";
SQL中,引号是用来限定包含特殊字符的标识符的,你的SQL中可以去掉,回车换行也可以去掉,结果都是一样的
FROM DB2ADMIN.ACTIVITY ACTIVITY";