select * FROM SCTRL_D WHERE CTRL_CD='S3' AND CTD_NM=N'男' --UPDATE SCTRL_D SET CTD_NM=N'阳' WHERE CTRL_CD='S3' AND CTD_NM=N'男' AND CO_CD='1000' select * FROM SCTRL_D WHERE CTRL_CD='S3' AND CTD_NM=N'女' --UPDATE SCTRL_D SET CTD_NM=N'阴' WHERE CTRL_CD='S3' AND CTD_NM=N'女' AND CO_CD='1000' select * FROM SCTRL WHERE CTRL_CD='S3' and CTRL_NM=N'性别' --UPDATE SCTRL SET CTRL_NM=N'阳历阴历区分编号' WHERE CTRL_CD='S3' and CTRL_NM=N'性别' AND CO_CD='1000'