May 13, 2007 at 5:53 am
Hi all,
I generated a script file for few tables of my database, and I am not unable to execute those scripts, as there are single quotes in few of the columns of those table in the script.
How can i remove the single quotes from the sql script, Can any one give me any idea about that.
- Manish
May 13, 2007 at 8:16 pm
If those quotes are in column names then use [] for column names.
If they are in data you scripted then duplicate quotes when you are scripting data.
Like this:
select REPLACE(ColName, '''', '''''')
_____________
Code for TallyGenerator
May 13, 2007 at 9:08 pm
Who are you and what have you done with the real Serqiy? The real Serqiy I know would have said something about going back and fixing the database so there are no quotes in column names.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 14, 2007 at 12:01 am
Don't forget to hunt down and torture the person that used quotes in column names.
No, I'm not the real Sergiy in disguise.
May 14, 2007 at 6:02 am
Yeah... that's what I mean Stuff like that...
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply