求助：sql server 2000, 这句话怎么写? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

求助：sql server 2000, 这句话怎么写?

求助：sql server 2000, 这句话怎么写?# Database - 数据库

A*s2002-09-10 07:09

1 楼

"UPDATE patient SET name = STUFF(name,CHARINDEX("'",name),1,"`") WHERE
CHARINDEX("'",name) <> 0"
就是找出name这项中的单引号换成反单引号，但这个单引号怎么也价不进去，我该怎么办
啊？谢谢

j*o2002-09-10 07:09

2 楼

是不是要\'丫。

【在 A***s 的大作中提到】

: "UPDATE patient SET name = STUFF(name,CHARINDEX("'",name),1,"`") WHERE
: CHARINDEX("'",name) <> 0"
: 就是找出name这项中的单引号换成反单引号，但这个单引号怎么也价不进去，我该怎么办
: 啊？谢谢

A*s2002-09-10 07:09

3 楼

大哥，那是C

么办

【在 j*****o 的大作中提到】

: 是不是要\'丫。

v*m2002-09-10 07:09

4 楼

try this one:
UPDATE member SET email = STUFF(email,CHARINDEX('''',email),1,char(96))WHERE
CHARINDEX('''',email) <> 0

办

【在 A***s 的大作中提到】

A*s2002-09-10 07:09

5 楼

thx，just got the solution：
UPDATE member SET email = STUFF(email,CHARINDEX(char(39),email),1,'`')WHERE
CHARINDEX(char(39),email) <> 0

么

【在 v**m 的大作中提到】

: try this one:
: UPDATE member SET email = STUFF(email,CHARINDEX('''',email),1,char(96))WHERE
: CHARINDEX('''',email) <> 0
:
: 办

v*m2002-09-10 07:09

6 楼

I am glad things work out finally. There are a few question, just curious.
First, how did u add the single quote to the database? I guess it should be
two single quote, that's why you need use char(39) to get it. Second, how can
you put '`' there? copy & paste? I would suggest you use char(96) or correct
char() number.

STUFF(email,CHARINDEX('''',email),1,char(96))WHERE
怎

【在 A***s 的大作中提到】

: thx，just got the solution：
: UPDATE member SET email = STUFF(email,CHARINDEX(char(39),email),1,'`')WHERE
: CHARINDEX(char(39),email) <> 0
:
: 么

p*e2002-09-10 07:09

7 楼

In SQL the character ' is used as escape character (plays the same role as \
in C) and quotation mark (similar to " in VB). So all ' in a string should be
replaced by ''.
Example 1: select all the tableName records where companyName is "Sam's Food":
Select * from tableName where companyName = 'Sam''s food'
Example 2: select all recordes where companyName containing ':
Select * from tableName where companyName like '%''%'

can
STUFF(email,CHARINDEX(char(39),email),1,'`')WHERE
该

【在 v**m 的大作中提到】

: I am glad things work out finally. There are a few question, just curious.
: First, how did u add the single quote to the database? I guess it should be
: two single quote, that's why you need use char(39) to get it. Second, how can
: you put '`' there? copy & paste? I would suggest you use char(96) or correct
: char() number.
:
: STUFF(email,CHARINDEX('''',email),1,char(96))WHERE
: 怎