create proc ss as begin if(@ds=12345) set @ds='asd' endexec ss
select replace(col,'12345','asd') from tb只能一个字段一个字段的代替如果整个表有请高人来写存储过程
-- ============================================= -- Author: T.O.P -- Create date: 2009/11/25 -- Version: SQL SERVER 2005 -- ============================================= declare @TB table([Col] varchar(14)) insert @TB select '12345sfds123' union all select '12345sfdsqwe12' union all select '12345sfddfs' union all select '12345sfdsaeq' union all select '12345sfsxcds' union all select '12345sfdcxs' union all select '12345sfdxzxs'select [Col], replace([Col],'12345','asd') as Col1 from @TB --测试结果: /* Col Col1 -------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 12345sfds123 asdsfds123 12345sfdsqwe12 asdsfdsqwe12 12345sfddfs asdsfddfs 12345sfdsaeq asdsfdsaeq 12345sfsxcds asdsfsxcds 12345sfdcxs asdsfdcxs 12345sfdxzxs asdsfdxzxs(7 row(s) affected)*/
select replace(col,'12345','asd') from tb
as
begin
if(@ds=12345)
set @ds='asd'
endexec ss
-- Author: T.O.P
-- Create date: 2009/11/25
-- Version: SQL SERVER 2005
-- =============================================
declare @TB table([Col] varchar(14))
insert @TB
select '12345sfds123' union all
select '12345sfdsqwe12' union all
select '12345sfddfs' union all
select '12345sfdsaeq' union all
select '12345sfsxcds' union all
select '12345sfdcxs' union all
select '12345sfdxzxs'select [Col], replace([Col],'12345','asd') as Col1
from @TB
--测试结果:
/*
Col Col1
-------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
12345sfds123 asdsfds123
12345sfdsqwe12 asdsfdsqwe12
12345sfddfs asdsfddfs
12345sfdsaeq asdsfdsaeq
12345sfsxcds asdsfsxcds
12345sfdcxs asdsfdcxs
12345sfdxzxs asdsfdxzxs(7 row(s) affected)*/