Hello! Hola! Hej!

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 ..

Database/MSsql 2014. 8. 29. 09:52

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

Database/MSsql 2013. 10. 17. 11:03

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..

Database/MSsql 2013. 8. 29. 15:28

DBCC CHECKIDENT ('WORK_INFORMATION', RESEED, 0)

Database/MSsql 2013. 7. 4. 18:04

Database/MSsql 2013. 5. 7. 17:24