Store .wav data type

Posted on 1999-12-08
Medium Priority
Last Modified: 2006-11-17
Hi there,
I would like to know if it is possible to store .wav files in SQL Server 7.0.

My client needs to store photos and sound files.  I'm using the image datatype to store the photos and can retrieve them 100% through MS-Access 97 with linked tables.

I however dont know which datatype to use for sound files.

Your expert advice would be appreciated!
Question by:maryka
1 Comment

Accepted Solution

gwamb earned 200 total points
ID: 2268655
U can use this datatype:

Variable-length binary data from 0 through 2,147,483,647 bytes (2 Gb)

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

601 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