如题 比如
insert into [Topic](Title,IP,UserLoginName,Contents,CreateTime) Values('dfdd','127.0.0.1','aaa','ddf'fa','2010/9/9 13:00:15')ddf'fa怎么存入db
insert into [Topic](Title,IP,UserLoginName,Contents,CreateTime) Values('dfdd','127.0.0.1','aaa','ddf'fa','2010/9/9 13:00:15')ddf'fa怎么存入db
use test
go
if object_id('test.dbo.tb') is not null drop table tb
go
create table tb(col varchar(100))
go
insert into tb select "天上''人间"
union all select "数据'库"
union all select "中国软件社区中心"
goselect * from tb where col like "%'%"/* 查询结果
col
-------------
天上''人间
数据'库
*/
insert into [Topic](Title,IP,UserLoginName,Contents,CreateTime) Values('dfdd','127.0.0.1','aaa',''ddf','fa'','2010/9/9 13:00:15')
该如何生成带双引号的sql语句 比如"dsf'df"
"\"" + txtbContent.Text + "\"" 这样生成sql语句时就变成"df'd"了
该如何生成带双引号的sql语句 比如"dsf'df"
"\"" + txtbContent.Text + "\"" 这样生成sql语句时就变成"df'd"了