초보 개발자의 메모장

SELECT B.name AS TABLE_NAME, A.name AS COLUMN_NAME INTO #TMP FROM syscolumns A INNER JOIN sysobjects B ON A.id = B.id AND B.type='u' INNER JOIN systypes C ON A.xtype=C.xtype AND C.name in ('text', 'ntext', 'char', 'nchar', 'varchar', 'nvarchar') DECLARE @tablename sysname DECLARE @Where NVarchar(Max) DECLARE @SQL NVARCHAR(Max) DECLARE @SEARCH NVARCHAR(200) SET @tablename = 'TABLE_NAME' SET @SEAR..

Oracle ⇒ SELECT TO_CHAR(SYSDATE, ‘yyyymmddhh24miss’) FROM DUAL; MSSQL ⇒ SELECT CONVERT(CHAR(8),GETDATE(),112) + REPLACE(CONVERT(CHAR(8),GETDATE(),108),':',''); -- 20230111171753 (2123년 1월 11일 17시 17분 53초)

DataType Mapping posgreSQL MSSQL Description BIGINT BIGINT 64-bit integer BOOLEAN BOOLEAN 1, 0 or NULL BYTEA BINARY(n) IMAGE ROWVERSION TIMESTAMP VARBINARY(n) VARBINARY(max) binary data (“byte array”) CHARACTER(n) CHAR(n), CHARACTER(n) fixed-length character string DATE DATE Date includes year, month, and day DOUBLE PRECISION (Alias FLOAT8) DOUBLE PRECISION FLOAT(p) double precision floating-poi..