473,408 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

What is the best data type for storing different file types in ms sql server 2008 r2?

What is the best data type for storing different file types in ms sql server?
May 23 '12 #1
1 2187
Rabbit
12,516 Expert Mod 8TB
There's only one type that can store files, and that's the binary data type. But you should think about just storing the location of the file.
May 23 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Dave Smithz | last post by:
Hi There, I have taken over someone else's PHP code and am quite new to PHP. I made some changes and have implemented them to a live environment fine so far. However, I now want to setup a...
1
by: moondaddy | last post by:
I'm bringing data from sql server into xml and one column is a tinyint data type in sql server. what's the equivalent of tinyint in xml? Thanks. -- moondaddy@nospam.com
2
by: Joey | last post by:
I have a web app that uses forms authentication. The app also has a downloads section, and I need to be able to use <location> tags to control access to the downloadable files there (preferably by...
2
by: Big Santini | last post by:
Question: how to 'execute' different file types? in example when user choose ..doc file, the deafult application for .doc should run. jaro
6
by: Bill Nguyen | last post by:
I need to detect and open PDF (acrobat reader or Adobe Acrobat), TIFF (MODI or Windows Picture and Fax Viewer) and some other document typ from within a VB.NET app at runtime. What commands/syntax...
7
by: Veeru | last post by:
Hi , What is the data type of Vptr pointer used in the virtual funtion mechanism? i suppose its void. Please correct me if i am wrong... Regards, Veeru
2
by: boyhiso | last post by:
Hi, I'm new in this...is there are someone know the data type for ISBN and year ?
8
by: Tem | last post by:
What would be the best data type for storing objects in a 2D array. the ideal type would be one like generic List but Lists are only 1D. i don't think i can have an array of lists. The size of...
1
by: pugalenthi | last post by:
I need to store a c# variable of data type timestamp into the SQL Server 2005 database. An example of how the variable value looks is as follows, 00:00:01.5000000 It represents the...
2
by: Justin | last post by:
I am getting this error when running on my local instance of SQL server, but it is not an issue when running on our development SQL Server box. Code: --variable declarations declare...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.