- [Query] :
SELECT count(*) as cnt
FROM portal_english.dbo.en_epilogue A
INNER JOIN (
SELECT * FROM (
SELECT
idx as lec_no,
pack_name,
'' AS lec_teacher_code1,
'' AS lec_teacher_code2,
'' AS lec_teacher_code3,
pack_yn
FROM portal_english.dbo.en_package
UNION ALL
SELECT
lec_no,
lec_name,
lec_teacher_code1,
lec_teacher_code2,
lec_teacher_code3,
'N'
FROM portal_english.dbo.en_lecture
) AAAA
) C
ON A.ep_code = C.lec_no
LEFT OUTER JOIN portal_english.dbo.en_member B
ON A.member_id = B.membersq
WHERE TRY_CONVERT(INT, C.lec_no) IS NOT NULL AND A.co_id IS NULL - [Error] : 쿼리를 실행할 수 없습니다.
Array
(
[0] => Array
(
[0] => 22018
[SQLSTATE] => 22018
[1] => 245
[code] => 245
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]varchar 값 '-1 OR 2+725-725-1=0+0+0+1 -- '을(를) 데이터 형식 int(으)로 변환하지 못했습니다.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]varchar 값 '-1 OR 2+725-725-1=0+0+0+1 -- '을(를) 데이터 형식 int(으)로 변환하지 못했습니다.
)
)
1