New To Databasing

I have just a general question that I was hoping to have answered about the SQL Server Express edition software. I was looking at the data types that you can select from while creating tables and was wondering about other types of data that it can support. I wanted to find out if it supports audio files as one of the data types. I know from MS Access its a OLE object datatype that supports audio files. Is SQL Server Express even capable of handling such data types? Or any other data types that are not text or integers? Anybodys input would be greatly appreciated. Thanks! ~[MikE]~

You can store any file (or data) as raw binary with the varbinary datatype.

Use varbinary(max) to store data larger than 8000 bytes.

|||Hey thanks for clearing that up for me, I really appreciuate the help, you're like the only one that resoponded out of 20 views, and yea I know it was probably a dumb question, but I just need to make sure. Thanks a lot! ~[MikE]~
|||

No question is dumb, it would be naive to think like that. Some questions can be answered by searching but then it is not always obvious what to search for.

Browse around a bit and you might be able to help others here, with something that you have experience with. This is a community where we help each other. It might take some time but most questions gets answered.

|||Hey thanks Andreas! Im looking foward to learning a lot from everybod on here. Much Appreciated!sql

New SQL Datatypes

I started experimenting with SQL Server 2008, June CTP. So the first thing I tried to do is to create a new table having as column types the new datatypes available in Katmai. According to a MS white paper new sql data types include Filestream, Date, Time. Does June CTP include those new types? Am I making a wrong assumption?

Thank you

All the new datatypes are scheduled for a later release, so unfortunately we'll just have to wait.

The what's new section i BOL is pretty handy if you wonder what you can play with

|||As referred you might have to wait or see for next 2 CTP releases on the changes, if you have observed in Katmai BOL or not there are blank placeholders for such features inclusion or make them deprecated based upon the CONNECT feedback or by popularity.sql

New report controls

I've read that RDL is extensible. Is it possible to write a new control that will go into your toolbox for a report?
IE - Different types of charts or listing view or something?
ThanksNot in v1. However this is on our wishlist for Yukon. (SQL Server 2005).
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:erDhLkgWEHA.500@.TK2MSFTNGP09.phx.gbl...
> I've read that RDL is extensible. Is it possible to write a new control
> that will go into your toolbox for a report?
> IE - Different types of charts or listing view or something?
> Thanks
>

New data types in SQL Server 2005

SQL Server 2005 has some new data types like XML, varchar(MAX). Are they
supported by C# in Visual Studio 2003 and 2005?Hi Roy
From http://tinyurl.com/c2glu
DataTypes - UDTs, the XML data type, and "MAX" BLOBs and CLOBs
SQL Server 2005 adds support for user-defined types, a native XML data type
and better large data support. Large data support is improved by using the
Transact-SQL types VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX).
User-defined types and a native XML type are defined by the SQL:1999 and
SQL:2003 specifications. To use these data types with SqlClient, new classes
in the System.Data.SqlTypes namespace are defined (SqlUdt and SqlXml),
support is added to the SqlDbTypes enumeration and IDataReader.GetValue was
enhanced to support returning UDTs as .NET Object types, and support
returning XML as a .NET String.
These new SQL Server 2005 types are supported in DataReaders returned from
SQL SELECT statements and as Parameters using SqlParameter. A special class,
SqlMetaData, can return information about extended properties of these new
data types, such as the XML schema collection that a strongly typed XML
column adheres to, or the database name of a UDT. You can use these types
from the client directly, in generic code, and also in the DataSet. Finally
you can perform partial updates on the "MAX" data types from the client,
which required using special SQL functions before ADO.NET 2.0.
You may also want to look at the Hands-On Labs in the resource kit.
For more information check out http://msdn.microsoft.com/SQL/2005/
John
"Roy" wrote:

> SQL Server 2005 has some new data types like XML, varchar(MAX). Are they
> supported by C# in Visual Studio 2003 and 2005?