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 |
|
harriere
Starting Member
3 Posts |
 Posted - 2012-06-11 : 01:39:10
|
| I am having data like these"personal,social,networking"and i need to insert above into a varchar field in sql..without quotescan anyone help me pls...V.VIJAYhttp://harriernet.wordpress.com |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-06-11 : 02:36:43
|
[code]INSERT INTO some_table ( some_column )SELECT 'personal,social,networking'[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-06-11 : 06:34:31
|
| if you are going to store data in a comma separated column, excel is what you want, not SQL SERVER.How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
How to insert comma with the string value