Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
 Posted - 2010-11-20 : 05:57:58
|
| What i should do to escape apostropes(') present in a varchar datatype.EXAM: I have a table and it has a field whose data type is varchar. But now the entry for the field contains apostropes(') in it and i am not able to enter that data into the table.It gives me the below error:run time error '-2147217900(80040e14)'For example : The value which I want to enter is "Arijit B'ishas"So can someone plz help mekalyan Ashis Dey |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-20 : 08:00:47
|
| double the apostropheasd''asd==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Escape Spostropes