USE AdventureWorks2012; GO SELECT ProductNumber, Category = CASE ProductLine WHEN 'R' THEN 'Road' WHEN 'M' THEN 'Mountain' WHEN 'T' THEN 'Touring' WHEN 'S' THEN 'Other sale items' ELSE 'Not for sale' END, Name FROM Production.Product ORDER BY ProductNumber; GO USE AdventureWorks2012; GO SELECT ProductNumber, Name, "Price Range" = CASE WHEN ListPrice = 0 THEN 'Mfg item - not for resale' WHEN List..
create sequence dbo.seq_name as [int] start with 1 increment by 1 maxvalue 999999 declare @grn_sequence_no int = next value for dbo.seq_name select format(getdate(), 'yyyyMMdd') + '-' + format(@grn_sequence_no, 'd6') 참조 자료] 날짜 및 시간 스타일 https://docs.microsoft.com/ko-kr/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017 포멧(Format) https://docs.microsoft.com/ko-kr/sql/t-sql/func..
while문 declare @no_image_list table ( seq_no int primary key identity(1,1) ) declare @seq_no int select @seq_no=min(seq_no) from @no_image_list while @seq_no is not null begin select * from someone -- while 조건절(필수) select @seq_no=min(seq_no) from @no_image_list where seq_no > @seq_no end apply문 select * from first_table as ft cross apply ( select * from second_table as st where st.c1 = ft.c1 ) a..
declare @picking_no bigint = '' , @pl_cd varchar(10) = '' , @date_type int = 1 , @start_date datetime = '2020-5-31' , @end_date datetime = '2020-5-31' , @search_type int = 0 , @search_value varchar(25) = '' , @picking_status char(1) = 'A' begin declare @sql nvarchar(max) , @paramlist nvarchar(4000) set @sql = N' set nocount on declare @datetime_min_value datetime = ''1753-01-01'' if @end_date > ..
- Total
- Today
- Yesterday
- 특정 문자를 기준으로 자르기
- .submit()
- System.Diagnostics
- Task
- 제품 등록
- In App Purchase
- await
- 아이폰
- mssql
- 문자 자르기
- async
- nl2br
- 명령어
- 앱 스토어
- 진수 변환
- system.io
- html tag
- 공백제거
- hyper-v
- trim
- MainActor
- App Store
- FileUpload
- 상품 등록
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |