title: The statement did not return a result set. Java Error
body: <p>I am trying to delete data from a table from java using JDBC. First I am counting the no of rows and making sure the table is not empty and then Truncating the data. </p>
  
  <p>Here is the code I am using</p>
  
  <pre><code>  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
      Connection con = DriverManager.getConnection("jdbc:sqlserver://m-i:1433;databaseName=Tes", "sa", "Password");
      Statement cnnt= con.createStatement();
      Statement del1 = con.createStatement();
      ResultSet rs = cnnt.executeQuery("Select count(lea) AS cnt from dbo.Link");
     int count= 0;
      if(rs.next())
      {
          count = rs.getInt("cnt");
      }
    System.out.println(count);
   if(count != 0)
   {
     del1.executeQuery("Truncate Table dbo.Link");
   }
  else
     {
         System.out.println("Table is already empty");
     }
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code> Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:800)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
  </code></pre>
  
  <p>The error is at the Truncate Table dbo.Link.</p>
  
  <p>Am I doing this the right way?</p>
  
  <p>Can someone help me with this please.</p>
  
  <p>Thanks.</p>