【寻求帮助】 帮我看看该怎么插入这个字符 ”‘“ update tst set fDe=' Crab Meat Cuisines, Abalone, Shark[']s Fin and Bird[']s Nest' where name='ddd'Shark[']s 应该是 Shark's Bird[']s 应该是 Bird's 应该怎么样才能把 ' 正确弄入数据库啊 [] 这个也不行求高手 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Shark''sBird''s update tst set fDe=' Crab Meat Cuisines, Abalone, Shark''s Fin and Bird''s Nest' where name='ddd' update tst set fDe=' Crab Meat Cuisines, Abalone, Shark[''']s Fin and Bird[''']s Nest' where name='ddd' update tst set fDe=' Crab Meat Cuisines, Abalone, Shark''s Fin and Bird''s Nest' where name='ddd' create table tb(name varchar(10) , fDe varchar(100))insert into tb(name) values('ddd')goupdate tb set fDe=' Crab Meat Cuisines, Abalone, Shark''s Fin and Bird''s Nest' where name='ddd'select * from tbdrop table tb/*name fDe ---------- ---------------------------------------------------------------------------------------------------- ddd Crab Meat Cuisines, Abalone, Shark's Fin and Bird's Nest(所影响的行数为 1 行)*/ update tst set fDe='Crab Meat Cuisines, Abalone, Shark ''s Fin and Bird ''s Nest' where name='ddd' 求一递归查询sql语句 sql 多表连接聚合函数问题 如下更新查询该如何写 sql server 2000 备份和恢复方面的问题! 如何恢复存储过程xp_fileexist----在线等! sqlserver compact3.5 添加数据源出错问题 关于MSDE数据库备份和恢复的疑难问题! 为什么我在SQL 2000企业管理器建立表格时money和int类型的长度不能变? 如何知道SQL SERVER是否启动,且在SQL SERVER没启动时用程序来启动?(告急) 入WTO后,中国管理软件方面可能回需求很大,讨论吧!! xp下vb连接sql server2000问题 log explore
Bird''s update tst set fDe=' Crab Meat Cuisines, Abalone, Shark''s Fin and Bird''s Nest' where name='ddd'
insert into tb(name) values('ddd')
goupdate tb set fDe=' Crab Meat Cuisines, Abalone, Shark''s Fin and Bird''s Nest' where name='ddd'select * from tbdrop table tb/*
name fDe
---------- ----------------------------------------------------------------------------------------------------
ddd Crab Meat Cuisines, Abalone, Shark's Fin and Bird's Nest(所影响的行数为 1 行)
*/
update tst set fDe='Crab Meat Cuisines, Abalone, Shark ''s Fin and Bird ''s Nest' where name='ddd'