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 |
|
shashkun
Starting Member
2 Posts |
 Posted - 2008-08-17 : 04:25:53
|
hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word into notepad and provided delimiters for questions and answers but the entire question appears in a single line(it is big problem when question size is big)in the data base which i dont want to be ///Could anyone of you help me out? Note: We can insert the data from excel sheet into database but copying each and every question and options from word to excel is also hectic. If there is any other way please help me out.shashikanth kuntla |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-17 : 04:46:31
|
| Didnt get that? Whats the problem if entire question goes to single line? are you looking for spanning question over multiple fields? |
 |
|
|
shashkun
Starting Member
2 Posts |
Posted - 2008-08-19 : 14:21:43
|
| suppose there is a question is this format:main(){ int i; i=1; printf("value of i is",i);}if the question is in a single line it will be printed asmain(){ int i; i=1; printf("value of i is",i);}hope you understood.shashikanth kuntla |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-19 : 23:58:21
|
what is the source of these question ? Is there a CR+LF char(13) + char(10) at the end of each line ?Does your front end application when displaying the data handles the CR+LF ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Creating SQL server database for MCQ's