DJ메탈짱™의 Free Style

[MS-SQL] 휴대전화 포맷 "000-0000-0000" #분리 #SPLIT

declare @str varchar(20) set @str = '010-1234-5678' select substring(@str,1,charindex('-',@str)-1) , substring(@str,charindex('-',@str)+1,4) , substring(@str,charindex('-',@str,9)+1, 4)
일(job)/DBMS 2016. 1. 12. 16:12
[MS-SQL] 퍼센트 계산하기

SELECT CAST(CAST(F_JOINMEMBER AS FLOAT)/CAST(JOINMEMBER AS FLOAT)*100 AS DECIMAL)
일(job)/DBMS 2016. 1. 12. 16:11
[MS-SQL] System Table을 활용하여 컬럼정보 조회하기

1. Procedure Create/************************************************************************************* ' Procedure Name : sp_SelectTableColumnInfo_Second ' Written date : 2007.03.27 ' Writer : Bo H. Choi ' Contents : Table Information Select ( Column Name, Data Type, Column Length ) ' Updated by : ' Updated date : ' Updated contents : ' Sample : exec sp_SelectTableColumnInfo_Second 'Authors',..
일(job)/DBMS 2016. 1. 12. 16:09
이전 Prev 1 ··· 87 88 89 90 91 92 93 ··· 130 Next 다음