Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
Questionbackup in sqllocaldb Pin
dharmaa.m12-Jul-13 7:57
dharmaa.m12-Jul-13 7:57 
AnswerRe: backup in sqllocaldb Pin
NotPolitcallyCorrect12-Jul-13 8:36
NotPolitcallyCorrect12-Jul-13 8:36 
GeneralRe: backup in sqllocaldb Pin
dharmaa.m12-Jul-13 10:03
dharmaa.m12-Jul-13 10:03 
QuestionMysql query with date conditions not working in server Pin Pin
ven75312-Jul-13 4:11
ven75312-Jul-13 4:11 
GeneralRe: Mysql query with date conditions not working in server Pin Pin
Eddy Vluggen12-Jul-13 4:52
professionalEddy Vluggen12-Jul-13 4:52 
SuggestionDatabse for broadcasting company Pin
aman wangde11-Jul-13 12:34
aman wangde11-Jul-13 12:34 
GeneralRe: Databse for broadcasting company Pin
Eddy Vluggen12-Jul-13 7:57
professionalEddy Vluggen12-Jul-13 7:57 
QuestionExport data in SQL 2008 Pin
vkEE11-Jul-13 9:05
vkEE11-Jul-13 9:05 
Hi,

I just used the Import Export functionality in sql 2008 to export a table having about one million rows. I have exported to a flat file, and delimited with pipes.

For some reason, about 23,000 rows below, the one of the fields expands and as a result pulls down to the next row, creating a blank row, the data hence after is fine. Now and then we are getting these blank rows.

I have confirmed this data is of length 40 characters long or less.

What could be causing the odd line breaks in the flat file?

any ideas appreciated!!

Thanks!
AnswerRe: Export data in SQL 2008 Pin
Richard Deeming11-Jul-13 10:40
mveRichard Deeming11-Jul-13 10:40 
Questionbcp command in sql 2008 Pin
vkEE11-Jul-13 6:45
vkEE11-Jul-13 6:45 
AnswerRe: bcp command in sql 2008 Pin
NickPace11-Jul-13 7:10
NickPace11-Jul-13 7:10 
AnswerRe: bcp command in sql 2008 Pin
NickPace11-Jul-13 7:24
NickPace11-Jul-13 7:24 
GeneralRe: bcp command in sql 2008 Pin
vkEE11-Jul-13 8:07
vkEE11-Jul-13 8:07 
GeneralRe: bcp command in sql 2008 Pin
NickPace11-Jul-13 9:23
NickPace11-Jul-13 9:23 
QuestionWhat will be the connection string --- Please read the entire question first Pin
Biplob Singha Shee11-Jul-13 3:04
Biplob Singha Shee11-Jul-13 3:04 
AnswerRe: What will be the connection string --- Please read the entire question first Pin
Eddy Vluggen11-Jul-13 5:02
professionalEddy Vluggen11-Jul-13 5:02 
AnswerRe: What will be the connection string --- Please read the entire question first Pin
jschell11-Jul-13 9:08
jschell11-Jul-13 9:08 
QuestionConnection String of a MySql Database from another computer via LAN Pin
Biplob Singha Shee11-Jul-13 0:53
Biplob Singha Shee11-Jul-13 0:53 
AnswerRe: Connection String of a MySql Database from another computer via LAN Pin
Garth J Lancaster11-Jul-13 1:13
professionalGarth J Lancaster11-Jul-13 1:13 
GeneralRe: Connection String of a MySql Database from another computer via LAN Pin
Biplob Singha Shee11-Jul-13 1:29
Biplob Singha Shee11-Jul-13 1:29 
GeneralRe: Connection String of a MySql Database from another computer via LAN Pin
Garth J Lancaster11-Jul-13 1:44
professionalGarth J Lancaster11-Jul-13 1:44 
GeneralRe: Connection String of a MySql Database from another computer via LAN Pin
Biplob Singha Shee11-Jul-13 1:51
Biplob Singha Shee11-Jul-13 1:51 
GeneralRe: Connection String of a MySql Database from another computer via LAN Pin
Garth J Lancaster11-Jul-13 1:55
professionalGarth J Lancaster11-Jul-13 1:55 
GeneralRe: Connection String of a MySql Database from another computer via LAN Pin
Biplob Singha Shee11-Jul-13 2:01
Biplob Singha Shee11-Jul-13 2:01 
Questiondatabase Pin
Member 1015018110-Jul-13 18:13
Member 1015018110-Jul-13 18:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.