하랑파파꺼

SELECT DATEADD(day, 4, getdate())

SET NOCOUNT ON CREATE TABLE Coupon( CouponCode1 CHAR(19) NOT NULL, CouponCode2 CHAR(19) NOT NULL, CouponCode3 CHAR(19) NOT NULL, CouponCode4 CHAR(19) NOT NULL, CouponCode5 CHAR(19) NOT NULL ) GO DECLARE @CNT INT SET @CNT = 1 WHILE(@CNT

/*전체 테이블의 소유자 변경*/ SP_MSFOREACHTABLE 'sp_changeobjectowner ''?'' , ''dbo''' /*단일 테이블의 소유자 변경*/ EXEC sp_changeobjectowner 'LECTURE_PRE_FILE', 'dbo'

/* ID 값 초기화 DBCC CHECKIDENT([table_name], RESEED, 0) */

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo].[fn_Changedatetime] ( @sdate varchar(30) )RETURNS DATETIME AS BEGIN DECLARE @RETURNVALUE DATETIME BEGIN SELECT @RETURNVALUE=CASE WHEN CHARINDEX('오후',@sdate)>0 THEN DATEADD(HH,12,CONVERT (DATETIME, REPLACE(@sdate,'오후',''))) ELSE CONVERT (DATETIME,REPLACE(@sdate,'오전','') ) END END RETURN(@RETURNVALUE) END

/* ID 값 초기화 DBCC CHECKIDENT([table_name], RESEED, 0) */

/*전체 테이블의 소유자 변경*/ SP_MSFOREACHTABLE 'sp_changeobjectowner ''?'' , ''dbo''' /*단일 테이블의 소유자 변경*/ EXEC sp_changeobjectowner 'LECTURE_PRE_FILE', 'dbo'