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 |
|
sphericalx
Starting Member
10 Posts |
 Posted - 2008-12-31 : 02:20:34
|
| how can i insert a values with ' into the database?data type for name is varcharvalue to be entered in: M'Cinsert tblmembers (name) values ('M'C') <--- i will get a error msg since ' is being read as a quotationBelow is the error msg.Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near 'C'.Server: Msg 105, Level 15, State 1, Line 1Unclosed quotation mark before the character string ')'. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-31 : 02:25:16
|
| try like thisinsert tblmembers(name) values ('m''c') |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
insert values with '