MS-SQL
SQL SERVER 문자열 랜덤 뽑기
김뽀씨
2024. 1. 23. 17:13
DECLARE @CHAR NVARCHAR(MAX)
SET @CHAR = N'랜덤하게문자를뽑아보자집에가고싶다';
-- 랜덤뽑기
SELECT TOP 1 SUBSTRING(@CHAR, ABS(CHECKSUM(NEWID())) % LEN(@CHAR) + 1, 1) AS RandomChar
FROM sys.objects;