본문 바로가기

Database/MSsql

[MSSQL] DATEDIFF ( datepart , startdate , enddate ) DATEDIFF ( datepart , startdate , enddate ) Return Type int datepart Abbreviations year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms microsecond mcs nanosecond ns http://msdn.microsoft.com/en-us/library/ms189794.aspx DATEDIFF (Transact-SQL) - SQL Server DATEDIFF (Transact-SQL) In this article --> APPLIES TO: SQL Server ..
[MSSQL] AUTOINCREMENT 설정하기 MYSQL에서는 KEY값에다가 AUTOINCREMENT 라고 써주며 되었던 것 같은데, MSSQL에서는 조금 다른 것 같다. | 방법1. CREATE TABLE 테이블 생성 할 때, 컬럼명 옆에 아래와 같이 IDENTITY 라고 작성해 준다. [MEDIA_SEQ] [int] IDENTITY(1,1) NOT NULL, [CATEGORY] [nvarchar](50) NOT NULL, [FIMENAME] [nvarchar](50) NOT NULL, | 방법2. Microsoft SQL Server Management studio
MS-SQL DATETIME CONVERT 2007/09/21 14:35 번호출력값사용방법0Feb 22 2006 4:26PMCONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)102/22/06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)206.02.22CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)322/02/06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)422.02.06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)522-02-06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)622 Feb 06CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6)7Feb 22, 06CONVERT(CHAR(10), CU..
MSSQL AUTO INCREMENT INIT DBCC CHECKIDENT ('WORK_INFORMATION', RESEED, 0)
[MSSQL] Database 복원

티스토리툴바