본문 바로가기

MS-SQL48

SQL SERVER 문자열 랜덤 뽑기 DECLARE @CHAR NVARCHAR(MAX) SET @CHAR = N'랜덤하게문자를뽑아보자집에가고싶다'; -- 랜덤뽑기 SELECT TOP 1 SUBSTRING(@CHAR, ABS(CHECKSUM(NEWID())) % LEN(@CHAR) + 1, 1) AS RandomChar FROM sys.objects; 2024. 1. 23.
[MS-SQL] 테이블 설명 넣기 컬럼에 대한 설명만 넣어버릇했지.. EXEC SP_ADDEXTENDEDPROPERTY 'MS_DESCRIPTION', '테이블설명', 'USER',DBO, 'TABLE', 테이블명 -- 고정값 : 'MS_DESCRIPTION', 'User', 'Table' 예) EXEC SP_ADDEXTENDEDPROPERTY 'MS_DESCRIPTION', '데이터 관리', 'USER',DBO, 'TABLE', Manage ps) 업데이트는 이넘 sp_updateextendedproperty 2023. 4. 19.
SQL SERVER TempDB SELECT * FROM ( SELECT SUM(unallocated_extent_page_count) AS [free pages] , (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB] FROM tempdb.sys.dm_db_file_space_usage ) AS A cross JOIN ( SELECT SUM(size)*1.0/128 AS [size in MB] FROM tempdb.sys.database_files ) AS B SELECT SUM(internal_object_reserved_page_count) AS [internal object pages used] , (SUM(internal_object_reserved_page_.. 2023. 3. 2.
Float() 조심! float는 근사치! 무언가 정확한 숫자를 계산해야 된다면 money나 Decimal를 이용하자! https://learn.microsoft.com/ko-kr/sql/t-sql/data-types/data-types-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16 2023. 1. 26.

티스토리툴바