如果是数值型的:Name=12' insert into tt3 (tID3) SELECT replace(Name,'''','') from t_item
declare @dd table(name char(10)) declare @ddd table(name char(10)) sET QUOTED_IDENTIFIER OFF insert into @dd values("'sdfsdf") select * from @dd insert into @ddd (name) select name from @dd select * from @ddd 兄弟只要能插入就不会有问题的啊!
insert into tt3 (tID3) SELECT replace(Name,'''','') from t_item
declare @ddd table(name char(10))
sET QUOTED_IDENTIFIER OFF
insert into @dd values("'sdfsdf")
select * from @dd
insert into @ddd (name) select name from @dd
select * from @ddd
兄弟只要能插入就不会有问题的啊!
/*
(所影响的行数为 1 行)name
----------
'sdfsdf (所影响的行数为 1 行)
(所影响的行数为 1 行)name
----------
'sdfsdf (所影响的行数为 1 行)*/
declare @i varchar(100)
set @i='234'''
select @i
select replace(@i,'''','')
-----------------------------
----------
234'(1 row(s) affected)
------
234(1 row(s) affected)