목록DB/MSSQL (16)

develog

[MSSQL] 프로시저 소스

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' ORDER BY ROUTINE_NAME ; SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' ORDER BY ROUTINE_NAME ; EXEC SP_HELPTEXT SP_CHESS_MAIN_TASK_INFO ;
DB/MSSQL 2019. 3. 29. 16:39
[MSSQL] 기본 명령어

현재 DB명select db_name() DB 변경use my_db
DB/MSSQL 2019. 3. 26. 11:13
[MSSQL] date

SELECT GETDATE()SELECT SYSDATETIME()SELECT CAST(GETDATE() AS DATE)SELECT CONVERT(CHAR(8), SYSDATETIME(), 112)SELECT CONVERT(DATETIME, CONVERT(CHAR(8), SYSDATETIME(), 112))
DB/MSSQL 2017. 5. 26. 12:27
[MSSQL] insert all

INSERT INTO TB_LIST (COL1, COL2) VALUES ('VAL11', 'VAL12'), ('VAL21', 'VAL22') ;
DB/MSSQL 2017. 4. 13. 17:07
[MSSQL] 주석 등록, 삭제, 조회

http://dbexpert.tistory.com/1
DB/MSSQL 2017. 4. 12. 17:29
[MSSQL] 결과창 그리드

SSMS (Sql Server Management Studio)결과창 포멧 변경Ctrl + D : 그리드Ctrl + T : 텍스트Ctrl + Shift + F : 파일
DB/MSSQL 2017. 4. 12. 15:41
Prev 1 2 3 Next