정훈's 프로그래밍

문자열 식의 값을 연결하고 그 사이에 구분 기호 값을 추가합니다. 구분 기호는 문자열 끝에 추가되지 않습니다. USE AdventureWorks2019 GO SELECT STRING_AGG(CONVERT(NVARCHAR(max), ISNULL(FirstName,'N/A')), ',') AS csv FROM Person.Person; GO

select xso.packing_no ,max(xso.seller_id) from dbo.table as xso with(nolock) where xso.packing_no in ( select distinct [value] from string_split(@packing_no, ',') ) group by xso.packing_no -- 영문순으로 정렬 order by case when max(xso.seller_id) like '[a-za-z]%' then 0 else 1 end , max(xso.seller_id)

세로행 -> 가로행으로 변경 CREATE TABLE Sales ( Salesperson VARCHAR(50), Region VARCHAR(50), Sales INT ); INSERT INTO Sales (Salesperson, Region, Sales) VALUES ('John', 'North', 100), ('John', 'South', 150), ('John', 'East', 75), ('Mary', 'North', 200), ('Mary', 'South', 50), ('Mary', 'East', 125); SELECT Salesperson, [North], [South], [East] FROM ( SELECT Salesperson, Region, Sales FROM Sales ) AS SourceT..

Returns the number of characters of the specified string expression, excluding trailing spaces. 문자 수를 반환합니다. LEN ("string_expression")

This function searches for one character expression inside a second character expression, returning the starting position of the first expression if found. 특정 문자열의 시작 위치 값을 반환합니다. DECLARE @document VARCHAR(64); SELECT @document = 'Reflectors are vital safety' + ' components of your bicycle.'; SELECT CHARINDEX('bicycle', @document); GO

목차 TRIM (Transact-SQL) STRING_SPLIT (Transact-SQL) 준비중... STRING_SPLIT (Transact-SQL) SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');

목차 TRIM (Transact-SQL) STRING_SPLIT (Transact-SQL) 준비중... TRIM (Transact-SQL) SELECT TRIM( ' test ') AS Result;

최근 실행된 문의 영향을 받은 행 수를 반환합니다. 행 수가 20억 개보다 많을 경우 ROWCOUNT_BIG을 사용하세요. USE AdventureWorks2012; GO UPDATE HumanResources.Employee SET JobTitle = N'Executive' WHERE NationalIDNumber = 123456789 IF @@ROWCOUNT = 0 PRINT 'Warning: No rows were updated'; GO

USE AdventureWorks2012; GO SELECT ProductNumber, Category = CASE ProductLine WHEN 'R' THEN 'Road' WHEN 'M' THEN 'Mountain' WHEN 'T' THEN 'Touring' WHEN 'S' THEN 'Other sale items' ELSE 'Not for sale' END, Name FROM Production.Product ORDER BY ProductNumber; GO USE AdventureWorks2012; GO SELECT ProductNumber, Name, "Price Range" = CASE WHEN ListPrice = 0 THEN 'Mfg item - not for resale' WHEN List..

create sequence dbo.seq_name as [int] start with 1 increment by 1 maxvalue 999999 declare @grn_sequence_no int = next value for dbo.seq_name select format(getdate(), 'yyyyMMdd') + '-' + format(@grn_sequence_no, 'd6') 참조 자료] 날짜 및 시간 스타일 https://docs.microsoft.com/ko-kr/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017 포멧(Format) https://docs.microsoft.com/ko-kr/sql/t-sql/func..