第一个select ManageDeptCode as DeptCode,ManageDeptName as DeptName from "000".tbManageDept
要求:增加一列,叫做DeptTypeID 并赋值为0第二个select * from
(
select a.NodeCode as DeptCode,b.NodeName as DeptName,a.StoreTypeID from "000".tbDepartment a
inner join "000".tbNode b on a.NodeCode = b.NodeCode
) c
where StoreTypeID=0 or StoreTypeID = 2要求:增加一列,叫做DeptTypeID 并赋值为1
要求:增加一列,叫做DeptTypeID 并赋值为0第二个select * from
(
select a.NodeCode as DeptCode,b.NodeName as DeptName,a.StoreTypeID from "000".tbDepartment a
inner join "000".tbNode b on a.NodeCode = b.NodeCode
) c
where StoreTypeID=0 or StoreTypeID = 2要求:增加一列,叫做DeptTypeID 并赋值为1
这样?
select ManageDeptCode as DeptCode,ManageDeptName as DeptName,0 as DeptTypeID from "000".tbManageDept
2.
select * from
(
select a.NodeCode as DeptCode,b.NodeName as DeptName,a.StoreTypeID,1 as DeptTypeID from "000".tbDepartment a
inner join "000".tbNode b on a.NodeCode = b.NodeCode
) c
where StoreTypeID=0 or StoreTypeID = 2
select ManageDeptCode as DeptCode,ManageDeptName as DeptName into #a from "000".tbManageDept
alter table #a add DeptTypeID bit default 0 with values
select * from #a
--==================
select * into #b from( select a.NodeCode as DeptCode,b.NodeName as DeptName,a.StoreTypeID from "000".tbDepartment a inner join "000".tbNode b on a.NodeCode = b.NodeCode ) c where StoreTypeID=0 or StoreTypeID = 2
alter table #b add DeptTypeID bit default 1 with values
select * from #b
--===================
删除2个临时表 (如果要保留到其他地方,请保留后删除)
drop table #a
drop table #b
select 0 as DeptTypeID, ManageDeptCode as DeptCode, ManageDeptName as DeptName from "000".tbManageDept 第二个,模仿这个在括号内做类似的查询,就可以了。