791 reputation
10
bio website
location
age
visits member for 10 months
seen 8 hours ago
stats profile views 425

12h
comment How to insert big list of Data in DB?
@OleksandrR. don't think negatively on me. I am little bit poor in English, every time I spend more time for posting the question.still I didn't explain properly to you.since onward I will put more effort for posting.
2d
comment How to insert big list of Data in DB?
@Ajasja If I mention "mx.gz" instead of "CSV".it showing error like ExportString::format: mx.gz is not a recognized ExportString format .
2d
comment How to insert big list of Data in DB?
@Mohsen Thanks.your code working fine..But I will try to convert binary format and again convert binary back to the list format.
2d
revised How to insert big list of Data in DB?
added 3 characters in body
2d
comment How to insert big list of Data in DB?
I will modify the question.
2d
comment How to insert big list of Data in DB?
Thanks for your answer,but my use cases are different.I want to insert that entire big data in single row in DB Table.
2d
comment How to insert big list of Data in DB?
let us continue this discussion in chat
2d
comment How to insert big list of Data in DB?
@Mohsen I didn't understood,what you put the comment.can you explain.
2d
comment How to insert big list of Data in DB?
@Mohsen According to my App requirements,we are not searching any data from biglist.the only thing is based on Date,we are fetching that corresponding bigData.so we built design like this.
2d
revised How to insert big list of Data in DB?
added 8 characters in body
2d
comment How to insert big list of Data in DB?
Actually,in my database design,one table is there with 3 columns names are date,bigData,tagId.each date have biglist of data.that's lenght is more than 60000.If I insert each value in row wise,entire my database design will be collapsed.so I need to insert entire bigList into single row.
2d
revised How to insert big list of Data in DB?
added 430 characters in body
2d
asked How to insert big list of Data in DB?
May
19
comment How can I connect to a SQLServer database without login details?
@SjoerdC.deVries What you said,that's right I found it where is the problem.. Thank you
May
19
asked How can I connect to a SQLServer database without login details?
May
18
comment How can I import images from a Microsoft SQLServer database?
I tried same procedure for PDF and .Txt.upto Fromcharactercode step is working.the next step ImportString is not working. I tried with the following code ImportString[%, "PDF"]
May
18
accepted How can I import images from a Microsoft SQLServer database?
May
18
comment How can I import images from a Microsoft SQLServer database?
,How you are Identifying ,This data is Hexdecimal data or another one.where you are finding this information.can you provide that link,I will also read that. Thank you..
May
18
comment How can I import images from a Microsoft SQLServer database?
Thanks,your code is working fine.I faced another problem about data I got another format of data from DB.it's format is in the following way 0xFFD8FFE000104A46494600010201006000600000FFE..This data starts with 0x.I tried same procedure(what you mention) with this data.I faced problem at`FromCharacterCode`step.because this data starts with 0x.how can I reslove this.For my testing I removed 0xfrom the list and continued same procedure.it's working fine But the problem was I am not getting exact image.
May
17
comment How can I import images from a Microsoft SQLServer database?
@SjoerdC.deVries I edited my question.can you check it once.