工具材料：

手機

電腦

操作方法

01

不知道你說的是哪種情況，我理解的有2種，1是對插入源進行過濾，2是對插入的某些值作判斷，是某個特定值時轉換成另一個值。

02

--情況1：使用Insert Into Select語法實現--透過拼接結果集作為Select資料來源之後可以加Where條件Insert Into YourTable (id,name,status，remark)

03

Select id,name,status，remark From (Select 1 as id,"張三" as name,"在職" as status,"沒有備註" as remark Union Select 2,"李四","離職","") as s Where id>2 And id<5--條件

04

--情況2：給插入值作特殊判斷Insert Into YourTable (id,name,status，remark)Select id,name,Case When status="在職" Then 1 WHen status="離職" Then 2 Else 0 End，remark From (。

05

Select 1 as id,"張三" as name,"在職" as status,"沒有備註" as remark Union Select 2,"李四","離職",") as s。