Click here to Skip to main content
14,331,044 members
   

Database

 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 22:40
memberMycroft Holmes11-Mar-13 22:40 
GeneralRe: How to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri11-Mar-13 23:44
memberAnubhava Dimri11-Mar-13 23:44 
Questiondatabase design for a self food ordering system? Pin
suryakanthithommy11-Mar-13 6:40
membersuryakanthithommy11-Mar-13 6:40 
AnswerRe: database design for a self food ordering system? Pin
Sandeep Mewara11-Mar-13 7:04
mentorSandeep Mewara11-Mar-13 7:04 
Questionwhy i am unable to retrieve holiday name Pin
Member 870181310-Mar-13 22:35
memberMember 870181310-Mar-13 22:35 
AnswerRe: why i am unable to retrieve holiday name Pin
Mycroft Holmes10-Mar-13 23:20
memberMycroft Holmes10-Mar-13 23:20 
GeneralRe: why i am unable to retrieve holiday name Pin
Member 870181311-Mar-13 4:31
memberMember 870181311-Mar-13 4:31 
QuestionBCP - Exported files (docx, xlsx & pptx) are corrupted Pin
ragasai10-Mar-13 16:52
memberragasai10-Mar-13 16:52 
Hi,

I am using the below bcp command to export the binary files from the filestream db and all other files are seems to be exported fine (i.e. txt, pdf, rtf, image files & etc) except docx, xlsx & pptx files. I am able to export these files (i.e. docx, xlsx & pptx) but I am getting a warning/error message when opening those files and then it opens the file properly.

BCP "SELECT content FROM [dbo].[Contents] WHERE ID=1" queryout "C:\Temp\" -T -S (local) -f C:\Temp\files.fmt

I am getting the below message when opening docx, xlsx & pptx files:

XLSX - Excel found unreadable content and Do you want to recover the contents of this document? DOCX - The file test.docx cannot be opened bcos there are problems with the content and then Excel found unreadable content and Do you want to recover the contents of this document?

Also, I have this in my files.fmt file:

10.0
1
1 SQLBINARY 0 0 "\t" 1 content ""

Any help will be much appreciated.
QuestionDatabase design for E commerce web site Pin
subbaraogaddam8-Mar-13 19:44
membersubbaraogaddam8-Mar-13 19:44 
AnswerRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:04
membergvprabu8-Mar-13 20:04 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:21
membersubbaraogaddam8-Mar-13 20:21 
GeneralRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:31
membergvprabu8-Mar-13 20:31 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:40
membersubbaraogaddam8-Mar-13 20:40 
GeneralRe: Database design for E commerce web site Pin
Shameel11-Mar-13 4:51
professionalShameel11-Mar-13 4:51 
AnswerRe: Database design for E commerce web site Pin
Richard MacCutchan8-Mar-13 22:08
protectorRichard MacCutchan8-Mar-13 22:08 
AnswerRe: Database design for E commerce web site Pin
jschell10-Mar-13 6:30
memberjschell10-Mar-13 6:30 
Questiondb_accessadmin? Pin
ThePotty17-Mar-13 23:57
memberThePotty17-Mar-13 23:57 
AnswerRe: db_accessadmin? Pin
JammoD878-Mar-13 1:21
memberJammoD878-Mar-13 1:21 
GeneralRe: db_accessadmin? Pin
ThePotty18-Mar-13 1:53
memberThePotty18-Mar-13 1:53 
QuestionI keep running into xml format issues in various editors ... please advise Pin
RedDk7-Mar-13 11:13
memberRedDk7-Mar-13 11:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
RedDk7-Mar-13 12:13
memberRedDk7-Mar-13 12:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy7-Mar-13 19:45
memberDavidduraisamy7-Mar-13 19:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 0:54
memberDavidduraisamy8-Mar-13 0:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDk8-Mar-13 8:31
memberRedDk8-Mar-13 8:31 
Questionhow to unloch table in sql Pin
mhd.sbt7-Mar-13 7:38
groupmhd.sbt7-Mar-13 7:38 

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.