혹시 at substring(으)로 찾으셨나요?
블로그
- SQL Server에서 인덱스 재설계 방법 STEP 1) 느린 쿼리 수집 대표적으로: SELECT TOP 20 qs.total_elapsed_time / qs.execution_count AS avg_elapsed_time, qs.total_logical_reads / qs.execution_count AS avg_logical_reads, qs.execution_count, SUBSTRING(qt.text
- sum of comma separated values [fnSplit] (@list VARCHAR(8000), @delim CHAR(1) = ',' ) RETURNS TABLE AS RETURN WITH csvtbl(START, stop ID, LTRIM(RTRIM(SUBSTRING(@list, START, CASE WHEN stop > 0 THEN stop - START ELSE 0 END))) AS VALUE