ms-sql이구요
데이타 삭제시 이런메세지가 나옵니다.
고수님들 제발 도와주십시요. 부탁드리겠습니다.
----------------------------------------------------------------------
파생 테이블의 열이 파생되었거나 상수이므로 파생 테이블 'V0_CUSTOMER'을(를) 업데이트할 수 없습니다. No changes made to database. DELETE FROM V0_CUSTOMER WHERE custcd = '00000'
----------------------------------------------------------------------
SELECT
V0_CUSTOMER.custcd,
V0_CUSTOMER.custnm,
V0_CUSTOMER.col03,
V0_CUSTOMER.col04,
V0_CUSTOMER.col05,
V0_CUSTOMER.col06,
V0_CUSTOMER.col07,
V0_CUSTOMER.col08,
V0_CUSTOMER.col09,
V0_CUSTOMER.col10,
V0_CUSTOMER.col11,
V0_CUSTOMER.col12,
V0_CUSTOMER.col13,
V0_CUSTOMER.col14,
V0_CUSTOMER.col15,
V0_CUSTOMER.col16,
V0_CUSTOMER.col17,
V0_CUSTOMER.col18,
V0_CUSTOMER.col19,
V0_CUSTOMER.col20,
V0_CUSTOMER.col21,
V0_CUSTOMER.col22,
V0_CUSTOMER.col23,
V0_CUSTOMER.col24,
V0_CUSTOMER.col25,
V0_CUSTOMER.col26,
V0_CUSTOMER.col27,
V0_CUSTOMER.col28,
V0_CUSTOMER.col29,
V0_CUSTOMER.col30,
V0_CUSTOMER.col31,
V0_CUSTOMER.col32,
V0_CUSTOMER.col33,
V0_CUSTOMER.col34,
V0_CUSTOMER.col35,
V0_CUSTOMER.col36,
V0_CUSTOMER.col37,
V0_CUSTOMER.col38,
V0_CUSTOMER.col39,
V0_CUSTOMER.col40,
col40nm = (select custnm from t0_customer where custcd = V0_CUSTOMER.col40),
V0_CUSTOMER.col41,
V0_CUSTOMER.col42,
V0_CUSTOMER.col43,
V0_CUSTOMER.col44,
V0_CUSTOMER.col45,
V0_CUSTOMER.col46,
V0_CUSTOMER.col47,
V0_CUSTOMER.col48,
V0_CUSTOMER.col49,
V0_CUSTOMER.col50,
V0_CUSTOMER.col51,
V0_CUSTOMER.col52,
V0_CUSTOMER.col53,
V0_CUSTOMER.col56,
V0_CUSTOMER.i_date,
V0_CUSTOMER.i_user ,
col15nm = ( select cdnm from t0_etccode where major = '002' and minor = v0_customer.col15) FROM V0_CUSTOMER
WHERE V0_CUSTOMER.col04 = :as_gbn
|