▒ 하늘아래 땅위에서 ▒

저장프로시저(Stored Procedure)로 SELECT 한 후 recordcount 를 가져오면 -1 을 반환한다. 이럴때 RecordSet 의 CursorLocation 속성을 AdUseClient 로 설정하면 됨 set rs = new ADODB.RecordSetrs.CursorLocation = AdUseClientrs.open Conn, Qry, adOpenKeyset, adLockBatchOptimistic recordcount = rs.recordcount [참고] https://msdn.microsoft.com/en-us/library/ee252442(v=bts.10).aspx

10 31 2017 9:45AM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) 10/31/17CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 17.10.31CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 31/10/17CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 31.10.17CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 31-10-17CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) 31 10 17CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) 10 31, 17 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) 09:45:09..