Question

sql 语句 在查询的结果中在添加一列类型

select * from dbo.t_BH_content where @channelID='00001'
union all SELECT ch.* FROM dbo.t_BH_content ch
LEFT JOIN t_BH_RelChannel b ON b.f_content_ID=ch.f_content_ID
WHERE b.f_relchannel_ID='00001'
我想给 select * from dbo.t_BH_content where @channelID='00001'
添加一列type值都为1
给SELECT ch.* FROM dbo.t_BH_content ch
LEFT JOIN t_BH_RelChannel b ON b.f_content_ID=ch.f_content_ID
WHERE b.f_relchannel_ID='00001'
也添加一列type 值为2 怎么做阿 各位帮帮忙

Answer 1

select *,1 as Type from dbo.t_BH_content where @channelID='00001'
union all
SELECT ch.*,2 as Type FROM dbo.t_BH_content ch
LEFT JOIN t_BH_RelChannel b ON b.f_content_ID=ch.f_content_ID
WHERE b.f_relchannel_ID='00001'

这样就可以了

Answer 2

select *,1 type from dbo.t_BH_content where @channelID='00001'
SELECT ch.*,2 type FROM dbo.t_BH_content ch
LEFT JOIN t_BH_RelChannel b ON b.f_content_ID=ch.f_content_ID
WHERE b.f_relchannel_ID='00001'