Solved

SQL Equivalent of Access OLE Object field

Posted on 2013-06-22
12
1,220 Views
Last Modified: 2013-06-25
Hi

What is the SQL Equivalent of Access OLE Object field
0
Comment
Question by:murbro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 24

Accepted Solution

by:
Bitsqueezer earned 250 total points
ID: 39268570
Hi,

there is no real equivalent, but to save binary objects the recommended choice is "varbinary(MAX)".

Normally it's better not to save big binary objects into a table. It's better to use a normal file repository like a file server and then only save a link to this file into the database.

Cheers,

Christian
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 250 total points
ID: 39268733
Normally it's better not to save big binary objects into a table. It's better to use a normal file repository like a file server and then only save a link to this file into the database.
You are talking about BLOB which I agree is a poor idea but why bother ? Simply use FILESTREAM.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39268736
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39268800
Actually, I think the author should back up entirely and see why they were using the MS Access OLE Object.  I suspect there is a far more elegant way to solve this problem then just saving all that binary data.  If they are going to do that they may as well use Xml. :)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39268801
That last comment regarding Xml was said half in jest for Racim's benefit. I know he will get a kick out of it.
0
 

Author Closing Comment

by:murbro
ID: 39268969
Thanks very much
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39269182
That last comment regarding Xml was said half in jest for Racim's benefit. I know he will get a kick out of it.
:)

Though I appreciate the intent, I'd have to say that benefit and xml have quasi mutually exclusive meanings,  as far as I am concerned.

I invite you to read the following for more info...
http://workflow.healthbase.info/monographs/XML_myths_Browne.pdf
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39270193
Racim,

You know we will never agree on the merits (or lack) of Xml.  Certainly around that time when that article was written (2003) there was a lot of hype regarding Xml (as there is now IMHO with JSON), but if used wisely Xml has its place in the proverbial toolbox.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39270544
You know we will never agree on the merits (or lack) of Xml.
Yes I know but I hope to change your mind someday :).  No big deal.

The article underlines fundamental timeless flaws about the hierarchic structure of XML and hoping to get something out of this.   I guess I came to the conclusion that living without it is better that living with it.  

I am curious on what cases you consider to use XML wisely ?  Since I don't use XML at all I may give it a shot and see.

Regards..
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39273493
In the past (prior to SQL Server 2008) I have used it very effectively to pass a dynamic list of parameters.  The case where you you be passing one ID or several hundred.  Another case is when you had a large list of optional parameters to be passed to a Stored Procedure for say searching purposes.  These two use cases can now be replaced with Table Valued Parameters.

Another case, that is still valid is to use Xml in a Stored Procedure to create a comma delimited list.
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 39274381
Hi acperkins,

little hint: This was also possible with SQL Server 2005 (and maybe before): Instead of using a table valued parameter simply create a temp table which is available in all called stored procedures without the need of a parameter. The lifetime of a temp table ends after the SP which created it. And it's an often heard myth that table valued parameters are all stored in memory - in fact SQL Server also creates temp tables for them so you have no disadvantage of creating a temp table in case of forwarding a parameter list.

Cheers,

Christian
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39276719
This was also possible with SQL Server 2005 (and maybe before): Instead of using a table valued parameter simply create a temp table which is available in all called stored procedures without the need of a parameter.
Absolutely.  I should have clarified when calling Stored Procedures from .NET and using SQL Server 2005 the only way was to use Xml (or God forbid) a delimited string.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question