DataBase 19 다양한 함수

SELECT @@LANGID;

 

SELECT @@SERVERNAME;

 

SELECT @@SERVICENAME;

 

SELECT @@SPID AS 'ID', SYSTEM_USER AS [로그인사용자], USER AS [사용자];

 

SELECT @@VERSION;

 

SELECT SYSDATETIME(), GETDATE();

 

SELECT DATEADD(day, 100, '2014/10/10');

 

SELECT DATEDIFF(week, GETDATE(), '2022/10/19');

 

SELECT DATENAME(weekday, '2022/10/19');

 

SELECT DATEPART(year, GETDATE());

 

SELECT MONTH('2022/10/19');

 

SELECT DATEFROMPARTS('2022', '10', '19');

 

SELECT ABS(-100);

 

SELECT ROUND(1234.5678, 2), ROUND(1234.5678, -2);

 

SELECT RAND();

 

SELECT SQRT(10);

 

SELECT POWER(3,2);

 

USE sqlDB; SELECT COL_LENGTH('userTbl', 'name');

 

SELECT DB_ID(N'AdventureWorks'); SELECT DB_NAME(5);

 

SELECT OBJECT_ID(N'sqlDB.dbo.userTbl');

 

SELECT OBJECT_NAME(245575913);

 

SELECT CHOOSE(2, 'SQL', 'Server', '2012', 'DVD');

 

SELECT IIF(100 > 200, '맞다', '틀리다');

 

SELECT ASCII('A'), CHAR(65);

 

SELECT CONCAT('SQL', 'SERVER', 2012)  --또는

 

SELECT 'SQ' + 'SERVER' + '2012';

 

SELECT UNICODE('가'), NCHAR(44032);

 

SELECT CHARINDEX('Server', 'SQL Server 2012');

 

SELECT LEFT('SQL Server 2012', 3), RIGHT('SQL Server 2012', 4);

 

SELECT SUBSTRING(N'대한민국화이팅', 3, 2);

 

SELECT LEN('SQL Server 2012');

 

SELECT LOWER('abcdEFGH'), UPPER('abcdEFGH');

 

SELECT LTRIM('  공백앞뒤두개  '), RTRIM('  공백앞뒤두개  ');

 

SELECT REPLACE('SQL Server 2012', 'Server', '서버');

 

SELECT REPLICATE('SQL', 5);

 

SELECT REVERSE('SQL Server 2012');

 

SELECT SPACE(5) ;

 

SELECT STUFF('SQL 서버 2012', 5, 2, 'Server');

 

SELECT FORMAT (GETDATE(), 'dd/MM/yyyy');