34,837
社区成员




Insert into tb
SELECT * FROM [MYDB].[dbo].[TB] WHERE name = 'abc'
Insert into tb values(
'
--SQL Script
SELETE * FROM [MYDB].[dbo].[TB] WHERE name = 'abc'
'
)
create table tb(name varchar(50))
insert into tb values('abcd''efg')
select * from tb
/*
name
--------------------------------------------------
abcd'efg
(所影响的行数为 1 行)
*/
drop table tb
replace(@s,'''','&039;')