DECLARE @Table TABLE (ID int);
INSERT INTO @Table (ID)
    SELECT RecordID FROM tblData

SELECT * FROM @Table

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.FileNotFoundException;
import java.io.IOException;


public class Full_Code {


    public static void main (String[] args) throws ClassNotFoundException, SQLException, FileNotFoundException, IOException
    {
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        String Query = "", s;

        BufferedReader in = new BufferedReader(new FileReader("Query.txt"));
        while ((s = in.readLine())!=null) Query += s+"n"; in.close();
        in.close();

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=MyDB;user=VriL;password=987;");
        stmt = (Statement) con.createStatement();
        rs = stmt.executeQuery(Query);

        rs.close(); con.close(); stmt.close();
    }

}

ResultSet rs_version;
    String msmsql_sql="select @@VERSION as VERSION";
    rs_version=stmt.executeQuery(msmsql_sql);
        while (rs_version.next()){
        out.println("<b>"+rs_version.getString("VERSION")+"</b>");
        }