Images

When you have a column property set to image, does it link to or does it embed the image in the table?

Davids Learning

If you specify the coloumn as image, this simply means that you are storing binary data. The name image is sometime is bit misleading :-)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||If you needed to store an image like a tiff,bitmap,jpeg, what would you use?|||

Hi !

If you are in SQL Server 2005, I would prefer the VARBINARY(MAX),as the IMAGE and the TEXT are tro be deprecated in further versions. If you are on SQL Server 2000, I would prefer using either the IMAGE or the TEXT (in common it makes no difference, because they are nearly implemented the same way, beside that the TEXT type has some extra function which on work on that type). In this case, as you appearantly will need no functions of the TEXT type, I would choose IMAGE.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Image Data Type

Hello,
Does any one has any document or link about pros and cons of using Image
data type to store images? Specially performance point of view.
Thanks,
Mukesh
Well, it depends. A quick search on the web reveals this article:
http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
I hope this will get you started.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
> Hello,
> Does any one has any document or link about pros and cons of using Image
> data type to store images? Specially performance point of view.
> Thanks,
> Mukesh
|||Thanks Wei,
This will help a lot...
Thanks,
Mukesh
"Wei Xiao [MSFT]" wrote:

> Well, it depends. A quick search on the web reveals this article:
> http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
> I hope this will get you started.
>
> --
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
> news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
>
>

Image Data Type

Hello,
Does any one has any document or link about pros and cons of using Image
data type to store images? Specially performance point of view.
Thanks,
MukeshWell, it depends. A quick search on the web reveals this article:
http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
I hope this will get you started.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
> Hello,
> Does any one has any document or link about pros and cons of using Image
> data type to store images? Specially performance point of view.
> Thanks,
> Mukesh|||Thanks Wei,
This will help a lot...
Thanks,
Mukesh
"Wei Xiao [MSFT]" wrote:

> Well, it depends. A quick search on the web reveals this article:
> http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
> I hope this will get you started.
>
> --
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
> news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
>
>

I'm Looking For : ReportViewer tutorial With C# && .NET

Hi All ,

If you will send to me a link I'll be very grateful .

Thanks In Advance
Boaz Shalev.Take a look at the Web Analyzer starter kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx.|||That link redirects to this:
http://msdn.microsoft.com/vstudio/default.aspx

I'm Looking For : ReportViewer tutorial With C# && .NET

Hi All ,

If you will send to me a link I'll be very grateful .

Thanks In Advance
Boaz Shalev.Take a look at the Web Analyzer starter kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx.|||That link redirects to this:
http://msdn.microsoft.com/vstudio/default.aspx

IIS 6.0 with sql backend connectivity

Can somebody please send me a link or reference on how to
configure a website using IIS 6.0 to connect to a SQL on
the backend?
Thank you.
Bahij,
the topics you need to check out are ASP, ASP.NET, ADO, ADO.NET (there are
alternatives but this is a good starting place).
Searching for these topics on Google will give loads of decent sites. If you
are stuck, then email me and I can give you a simple demo page which works
against Northwind and you can just stick it in IIS to see the whole thing
working.
Regards,
Paul Ibison
|||Paul,
can you please email me that code sample to bnahhas@.austin.rr.com ?
Thank you so much for your time and effort.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Bahij,
actually found this for you on MSDN which is simpler than my example:
http://msdn.microsoft.com/library/de...vbscriptx.asp.
To get it to work, you'll need to add the windows user IUSR_IISCOMPUTERNAME
as a login on your sql server. If IIS and SQL are on the same box, nothing
else is required, but if not you'll need to change the following:
Data Source=" & _
Request.ServerVariables("SERVER_NAME")
to
Data Source=YourSQLServer
HTH,
Paul Ibison

IIS 6.0 with sql backend connectivity

Can somebody please send me a link or reference on how to
configure a website using IIS 6.0 to connect to a SQL on
the backend?
Thank you.Bahij,
the topics you need to check out are ASP, ASP.NET, ADO, ADO.NET (there are
alternatives but this is a good starting place).
Searching for these topics on Google will give loads of decent sites. If you
are stuck, then email me and I can give you a simple demo page which works
against Northwind and you can just stick it in IIS to see the whole thing
working.
Regards,
Paul Ibison|||Paul,
can you please email me that code sample to bnahhas@.austin.rr.com ?
Thank you so much for your time and effort.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Bahij,
actually found this for you on MSDN which is simpler than my example:
http://msdn.microsoft.com/library/d...evbscriptx.asp.
To get it to work, you'll need to add the windows user IUSR_IISCOMPUTERNAME
as a login on your sql server. If IIS and SQL are on the same box, nothing
else is required, but if not you'll need to change the following:
Data Source=" & _
Request.ServerVariables("SERVER_NAME")
to
Data Source=YourSQLServer
HTH,
Paul Ibison