摘要:ACCESS轉MS-SQL語法
IIf([簽約人識別碼] Is Null,0,1)
CASE WHEN [簽約人識別碼] IS NULL THEN 0 ELSE [簽約人識別碼] END
(CASE WHEN 班員編號< 10 THEN '0' + CAST(班員編號AS nvarchar) ELSE CAST(班員編號AS nvarchar) END)
REPLICATE('0', 10 - LEN(耕作識別碼)) + CAST(耕作識別碼 AS nvarchar)
摘要:ACCESS轉MS-SQL語法
IIf([簽約人識別碼] Is Null,0,1)
CASE WHEN [簽約人識別碼] IS NULL THEN 0 ELSE [簽約人識別碼] END
(CASE WHEN 班員編號< 10 THEN '0' + CAST(班員編號AS nvarchar) ELSE CAST(班員編號AS nvarchar) END)
REPLICATE('0', 10 - LEN(耕作識別碼)) + CAST(耕作識別碼 AS nvarchar)