根据SQL中的任何条件插入值

Question

declare @varID as INT = 2
insert into table1
(
ID
,varName
)
select
ID
,**#####**
from table2

我想要基于@varID的varName的值。我该怎么做呢?

应该用什么代替#####

?复制IF @varname = 2 then 'P' else 'I'语句。

Answer 1

你很接近了。只需在SELECT子句中提及变量。这样的。

declare @varID as INT = 2
insert into table1 (ID ,varName)
select  ID, 
CASE WHEN @varID = 2 THEN 'P' ELSE 'I' END
from table2

Answer 2

可能是下面的CASE WHEN THEN ELSE END语句

declare @varID as INT = 2
insert into table1
(
ID
,varName
)
select
ID
,CASE WHEN @varID=2 THEN 'P' ELSE 'I' END
from table2