CREATE trigger ab on table_name for insert
as
begin
declare @sql varchar(1000),@tblname varchar(250) ;
select @tblname=tablename from inserted;
set @sql='insert into news_hq (ts_cs,ts_pm ,ts_gg,ts_gc,ts_cz,ts_bz,ts_zd,ts_jg1,ts_jg2) select [城市*],[品名*],[规格*],[钢厂/产地*],[材质*],[备注],[涨跌],[最低价格*],[最高价格] from '+@tblname
exec(@sql);
end;
把[品名*]为 '无缝钢管' 替换为'无缝管' 单引号问题处理 插入news_hq
case
when charINDEX('无缝',[品名*])>0 Then replace([品名*],'无缝钢管','无缝管')
else [品名*]
end
as
begin
declare @sql varchar(1000),@tblname varchar(250) ;
select @tblname=tablename from inserted;
set @sql='insert into news_hq (ts_cs,ts_pm ,ts_gg,ts_gc,ts_cz,ts_bz,ts_zd,ts_jg1,ts_jg2) select [城市*],[品名*],[规格*],[钢厂/产地*],[材质*],[备注],[涨跌],[最低价格*],[最高价格] from '+@tblname
exec(@sql);
end;
把[品名*]为 '无缝钢管' 替换为'无缝管' 单引号问题处理 插入news_hq
case
when charINDEX('无缝',[品名*])>0 Then replace([品名*],'无缝钢管','无缝管')
else [品名*]
end
select 'wo''de'
--
wo'de
select [城市*],
[品名*] = case
when charindex(''无缝'',[品名*])>0
Then replace([品名*],''无缝钢管'',''无缝管'')
else [品名*]
end ,
[规格*],[钢厂/产地*],[材质*],[备注],[涨跌],[最低价格*],[最高价格] from '+@tblname