<div>
<div class="content wysiwyg-content">
Hello Expert<br />
<br />
I am trying to load an Audio file (.wma) into compact Edition Database.<br />
<br />
My audio file is in c:\Audio\ directory<br />
<br />
What is the SQL command that I execute from SQL Server Manager the load the file.<br />
<br />
Also what is the best data type to make the Audio field.<br />
<br />
I am a beginner, so detail code please<br />
<br />
Thanks
</div>
</div>


Hello Expert

I am trying to load an Audio file (.wma) into compact Edition Database.

My audio file is in c:\Audio\ directory

What is the SQL command that I execute from SQL Server Manager the load the file.

Also what is the best data type to make the Audio field.

I am a beginner, so detail code please

Thanks

Audio file in SQL Server CE

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.