오늘만살자

CREATE FUNCTION zerofill ( @value varchar(15) ) RETURNS char(15) AS BEGIN declare @fillChar varchar(15); declare @length int; declare @convertValue char(15); set @length = 15; set @fillChar = '00000000000000'; set @convertValue = right(@fillChar+@value, @length); return @convertValue END ex) select dbo.zerofill(number) as number from table;

select @@LANGUAGE select *from sys.databases alter database cloud35 set single_user with rollback immediate; alter database cloud35 collate Korean_Wansung_CI_AS alter database cloud35 set multi_user; 업데이트 / 삽입할때 N를 입력해서 실행한다. ex) update g_member set mem_name=N'테스트맨' where uid = 1