Sql replace ...
-
I need to replace this caracter " to nothing in my database but its not work. her som code. SqlCommand cmd1 = new SqlCommand("update c5 set name= replace(name,'"',''), conn); but its make error on visual studio but in micrsoft Sql Server managment its work fine. Error: Error 2 Too many characters in character literal ) expected ; expected ; expected Hope i can help me..
-
I need to replace this caracter " to nothing in my database but its not work. her som code. SqlCommand cmd1 = new SqlCommand("update c5 set name= replace(name,'"',''), conn); but its make error on visual studio but in micrsoft Sql Server managment its work fine. Error: Error 2 Too many characters in character literal ) expected ; expected ; expected Hope i can help me..
Stop and think about what you're telling the compiler. How does it work out that " is meant to be a quote within a string, and not the end of a string ? \" is a quote within a string, or "" if you put @ at the front, and \ then means \.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )