토실이네의 기억 저편으로

select CONSTRAINT_NAME from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME ='테이블명' 으로 제약조건 확인 후 alter table tb_cpn_order drop constraint FK_조건 을 삭제한다.

update tableName set fieldName=convert(datetime, '2010-02-11 09:48:24') where condition --시간은 24시간제로 할것.

SELECT   JUMIN FROM      MEMBER GROUP    BY JUMIN HAVING  COUNT(*)>1 윗분이 작성하신 쿼리처럼 위 쿼리는 증복된 해당 주민번호에 대해서 가지고옵니다. 추가 질문에서 증복된 주민번호를 삭제하실것이면 모두 삭제하실것인지?? DELETE  MEMBER  WHERE    A.P_JUMIN  IN                  (SELECT  B.P_JUMIN                    FROM      MEMBER b                   GROUP BY B.P_JUMIN                   HAVING  COUNT(*)>1                            ...

번호 출력값 사용방법 0 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) 1 02/22/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 2 06.02.22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 3 22/02/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 4 22.02.06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 5 22-02-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) 6 22 Feb 06 CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) 7 Feb 22, 06 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) 8 16:26:08 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8) 9 Feb 22 2006 4:26:08:020PM CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9) 10 02-22-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10) 11 06/02/22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11) 12 060222 CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12) 13 22 Feb 2006 16:26:08:020 CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) 14 16:26:08:037 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14) 20 2006-02-22 16:26:08 CONVERT(CHAR(19),...

-- CHARINDEX,CONVERT,REPLACE 를이용데이터입력 insert into test ( a , b , c ) values ( 1 , ' 홍길동 ' , case when   CHARINDEX ( ' 오후 ' , '2008-07-01 오전 11:29:34 ' )> 0        then dateadd ( hh , 12 , convert ( datetime , replace ( '2008-07-01 오전 11:29:34 ' , ' 오후 ' , '' )))        else convert ( datetime , replace ( '2008-07-01 오전 11:29:34 ' , ' 오전 ' , '' ) )        end ) insert into test ( a , b , c ) values ( 1 , ' 변학도 ' , case when   CHARINDEX ( ' 오후 ' , '2008-07-01 오후 02:11:34 ' )> 0        then dateadd ( hh , 12 , convert ( datetime , replace ( '2008-07-01 오후 02:11:34 ' , ' 오후 ' , '' )))        else convert ( datetime , replace ( '2008-07-01 오후 02:11:34 ' , ' 오전 ' , '' ) )        end ) -- 날짜변환하는부분을함수로작성 CREATE   FUNCTION dbo . fn_Changedatetime ...