update tb set name=b.name+name from tb,(select substring(code,1,2) as code,name from tb where substring(code,3,4)='0000') as b where substring(tb.code,1,2)=b.code and substring(tb.code,3,4)<>'0000'
解决方案 »
- 如何提高数据库设计能力
- 显示每个月每种商品发货量多少问题
- sql server 错误
- sql语句怎么写才能实现这样的效果?
- 求助,这段存储过程改成SQL语句该怎么该呀,看不懂,T.T..
- Reporting Services 2005中SubReport的使用
- SQL 语句求助!
- 如何将自增列还原为从1开始?
- sql 语句怎么写?上下合并用union,如果左右合并两个数据源怎么写?
- 如何对Sql Server 的Sql Script脚本在生成是自动加密(50分)
- 用Update更新一个超长的文本字段时出现"xxx标识符 太长。最大长度为 128"的错误,何解???????????
- 请 vivianfdlpw() 来领分·真的谢谢你
set
a.name = b.name+a.name
from
[table] a
(select code,name from [table] where code like '%0000') b
where
left(a.code,2) = left(b.code,2)
and
a.code not like '%0000'
set
a.name = b.name+a.name
from
[table] a,
(select code,name from [table] where code like '%0000') b
where
left(a.code,2) = left(b.code,2)
and
a.code not like '%0000'
insert into tablename select '410000', '江苏省'
union select '411000', '南京市'
union select '520000','浙江省'
union select '523000','杭州市'
union select '524000','宁波市'update A
set A.name=B.name+A.name
from tablename A inner join tablename B on left(A.code,2)=left(B.code,2)
where right(A.code,4)<>'0000'select * from tablenamecode name
------ --------------------
410000 江苏省
411000 江苏省南京市
520000 浙江省
523000 浙江省杭州市
524000 浙江省宁波市(所影响的行数为 5 行)
from tablename A , tablename B where left(A.code,2)=left(B.code,2)
(所影响的行数为 3 行)