第二个问题:
update 表 set
city = '北京'
where city = '四川'
update 表 set
city = '北京'
where city = '四川'
解决方案 »
- 求一个字符串模式匹配的写法
- jsp4种连接数据库方法
- 合并查询的数据集
- 子查询的IN只能返回一个字段,我用exists但不会用,谁能帮我下
- 请教个SQL技巧问题
- 关于视图的建立
- sql server语句修改设置字段问题
- 高分\在线等:sql sverver2005里的image字段,select出来后怎样insert到oracle里?
- 求教:sql语句中对特殊字符(如:'和,等)是如何处理的??
- 从别的电脑上拷贝SQLSERVER7。0的两个文件code_data.mdf',code_log.ldf' 到入的时候,硬盘响了,可是错误
- 我的SQL6.5数据库,单个库最大可以为多少?
- 有不同版本的SQL server的问题,新手不要进
(
zjlbbm varchar(20) ,
zjxm_name varchar(20)
)
goinsert into a(zjlbbm,zjxm_name) values('01','z01')
insert into a(zjlbbm,zjxm_name) values('02','z01')
insert into a(zjlbbm,zjxm_name) values('03','z01')
insert into a(zjlbbm,zjxm_name) values('04','z02')
insert into a(zjlbbm,zjxm_name) values('05','z03')
insert into a(zjlbbm,zjxm_name) values('06','z03')select zjlbbm,id=identity(int,1,1),zjxm_name into #t from aselect * from #tdelete #t
from
( select min(id) as id,zjxm_name from #t group by zjxm_name
) as no1
where #t.zjxm_name = no1.zjxm_name
and #t.id > no1.id
drop table #t
delete TableName where FileName=bb
insert into tableName select * from #tmp