sql server通过JAVA上的临时表从MSSQL数据库获取数据

Question

我尝试从MSSQL数据库获取数据，如下所示

ResultSet rs2;
Statement stmt;
String query2 ="USE DBOne\n" +
"DECLARE @temp_table table (column1 VARCHAR(60))\n" +
"insert into @temp_table (column1)\n" +
"select column1 from real_table (nolock)\n" +
"where date between '2014-08-14 10:00:00.000' and '2014-08-14 10:00:10.000'\n" +
"and column1 not like ''\n" +
"\n" +
"select column1 from @temp_table";

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl = "jdbc:sqlserver://192.168.131.10;" + "databaseName=DBOne;" + "user=" + "DBUser" + ";" + "password=" + "userpassword" + ";"; 
Connection con = DriverManager.getConnection(connectionUrl);
stmt = con.createStatement();

rs2 = stmt.executeQuery(query2);

while (rs2.next()) {

System.out.println(rs2.getString(1)); 

}

但是rs2奇怪地返回null。我怀疑@temp_表的创建在JAVA上有问题。因为没有创建临时表的同一个查询成功地工作了

String query2 ="USE DBOne\n" +
"select column1 from real_table (nolock)\n" +
"where date between '2014-08-14 10:00:00.000' and '2014-08-14 10:00:10.000'\n" +
"and column1 not like ''";

我不想为这个简单的事情创建数据库中的storedprocedure。你知道我该怎么解决这个问题吗