jaybee jong-bae

## postgresConfig.sql
SELECT
    name AS "설정 항목",
    setting AS "설정값",
    current_setting(name) AS "실제 적용된 값 (읽기 편한 버전)",
    unit AS "단위",
    short_desc AS "설명",
    source AS "설정 출처",
    pending_restart AS "재시작 필요여부"
FROM pg_settings
WHERE name IN (

## MSSQL_INFORMATION_SCHEMA.sql
SELECT  A.TABLE_NAME,
        A.ORDINAL_POSITION,
		CASE WHEN C.TABLE_NAME IS NOT NULL    THEN 'PK' ELSE ''  END PK ,
        A.COLUMN_NAME,
        DATA_TYPE,
        CHARACTER_MAXIMUM_LENGTH,
        IS_NULLABLE,
        COLUMN_DEFAULT,
		B.DESCRIPTION
FROM INFORMATION_SCHEMA.COLUMNS A

## mouseFollowShape.html
<!DOCTYPE html>
<!--
Created using JS Bin
http://jsbin.com

Copyright (c) 2024 by anonymous (http://jsbin.com/ravasowoyo/1/edit)

Released under the MIT license: http://jsbin.mit-license.org
-->
<meta name="robots" content="noindex">

## fnGetWeekNumber.sql
ALTER FUNCTION [dbo].[fnGetWeekNumber]
(
	-- @StartDayOfWeek 는 select @@DATEFIRST 설정에 따라서 달라짐 (@StartDayOfWeek varies according to the @@DATEFIRST setting.)
	-- : @@DATEFIRST 가 디폴트로  7 인데  7은 일요일임 (@@DATEFIRST defaults to 7, where 7 represents Sunday.)
	-- : @@DATEFIRST 가 일요일이면  @StartDayOfWeek 의 1의 값은 일요일임 (If @@DATEFIRST is set to Sunday, a value of 1 for @StartDayOfWeek represents Sunday.)

	@InputDate DATE,
	@StartDayOfWeek int
)
RETURNS INT

## how-to-write-by-markdown.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                jong-bae
                / how-to-write-by-markdown.md
            
            
              Created
              June 3, 2024 03:11
                — forked from ihoneymon/how-to-write-by-markdown.md
            
              
                마크다운(Markdown) 사용법
              
          
    [공통] 마크다운 markdown 작성법


영어지만, 조금 더 상세하게 마크다운 사용법을 안내하고 있는

"Markdown Guide (https://www.markdownguide.org/)" 를 보시는 것을 추천합니다. ^^


아, 그리고 마크다운만으로 표현이 부족하다고 느끼신다면, HTML 태그를 활용하시는 것도 좋습니다.

1. 마크다운에 관하여
	SELECT
	name AS "설정 항목",
	setting AS "설정값",
	current_setting(name) AS "실제 적용된 값 (읽기 편한 버전)",
	unit AS "단위",
	short_desc AS "설명",
	source AS "설정 출처",
	pending_restart AS "재시작 필요여부"
	FROM pg_settings
	WHERE name IN (
	SELECT A.TABLE_NAME,
	A.ORDINAL_POSITION,
	CASE WHEN C.TABLE_NAME IS NOT NULL THEN 'PK' ELSE '' END PK ,
	A.COLUMN_NAME,
	DATA_TYPE,
	CHARACTER_MAXIMUM_LENGTH,
	IS_NULLABLE,
	COLUMN_DEFAULT,
	B.DESCRIPTION
	FROM INFORMATION_SCHEMA.COLUMNS A
	<!DOCTYPE html>
	<!--
	Created using JS Bin
	http://jsbin.com

	Copyright (c) 2024 by anonymous (http://jsbin.com/ravasowoyo/1/edit)

	Released under the MIT license: http://jsbin.mit-license.org
	-->
	<meta name="robots" content="noindex">
	ALTER FUNCTION [dbo].[fnGetWeekNumber]
	(
	-- @StartDayOfWeek 는 select @@DATEFIRST 설정에 따라서 달라짐 (@StartDayOfWeek varies according to the @@DATEFIRST setting.)
	-- : @@DATEFIRST 가 디폴트로 7 인데 7은 일요일임 (@@DATEFIRST defaults to 7, where 7 represents Sunday.)
	-- : @@DATEFIRST 가 일요일이면 @StartDayOfWeek 의 1의 값은 일요일임 (If @@DATEFIRST is set to Sunday, a value of 1 for @StartDayOfWeek represents Sunday.)

	@InputDate DATE,
	@StartDayOfWeek int
	)
	RETURNS INT