sql数据库中有一段,执行存储过程时:当字段的值为1时修改成0当字段的值为0时修改成1该如何来写存储过程?
解决方案 »
- 望高手指点: 关于自动刷新的问题
- 面试题:写一递归和冒泡算法
- category.aspx?1,0,0,6,0 这个是什么传值
- 怎么判断dataset里是否存在第2个表?就是如何判断ds.tables(2)是否存在?
- 使用asp.net网站管理工具配置用户角色时遇到的问题
- asp.net初学者试用Visual Web Developer 2005,写的cs代码无法编译
- 求救:指定的参数已超出有效值的范围。参数名: 小时、分和秒参数描述无法表示的 DateTime 请问这是什么原因??
- 征求例子一个.(初学)
- 怎么让dropdownlist选中,且触发一个事件后,还选中那个选项?
- 怎么读取出datagrid每行的checkbox
- 求一sql if语句...急
- JS控制TextBox的ReadOnly 和Enabled属性
declare @a int
if @a =0
begin
print('0')
end
if @a =1
begin
print('1')
end
update DS_Brand set Passed=case Passed when 1 then 0 else 1 end where id=49
--或
declare @passed int
set @passed = (select passed from DS_Brand where id=49)
if(@passed=1)
update DS_Brand set Passed=0 where id=49
else
update DS_Brand set Passed=1 where id=49
update DS_Brand set Passed=case Passed when 1 then 0 else 1 end where id=49
--或
declare @passed int
set @passed = (select passed from DS_Brand where id=49)
if(@passed=1)
update DS_Brand set Passed=0 where id=49
else
update DS_Brand set Passed=1 where id=49
update DS_Brand set Passed=case Passed when 1 then 0 else 1 end where id=49
--或
declare @passed int
set @passed = (select passed from DS_Brand where id=49)
if(@passed=1)
update DS_Brand set Passed=0 where id=49
else
update DS_Brand set Passed=1 where id=49
IN "ID" VARCHAR(100)
begindeclare C_count int;
set C_count = (select "字段" from "表" where "ID"=CLID); if C_count = '1' then
update "表"
set "字段" = '0'
where "ID"=CLID
end if;if C_count = '0' then
update "表"
set "字段" = '1'
where "ID"=CLID
end if;go
from (
select 1 as id,
1 as isUsed
union
select 2,0
union
select 3,1) t
goselect * from NewTable
go
update NewTable set isUsed = case
when (isUsed=1) then 0
else 1 end
go
select * from NewTable