public void chkDate()
{
DataTable dt = new DataTable();
Console.WriteLine("select");
strSQL =
"select * from DEPT_BK R " +
"where exists " +
"(select * from DEPT X " +
"where R.KOUSHINBI < X.KOUSHINBI and R.DEPTNO = X.DEPTNO)";
dt = DBA(strSQL); //SQL実行
Console.WriteLine(strSQL);
Console.WriteLine(dt.Rows.Count + "行が更新対象\r\n");
}