Image and tables

Is it possible to save jpgs in a table if the DataType is set to varbinary(MAX), also how would I save the images to the table.

Thanks

Hi,

yes that possible, but depends on the used coding language, would be nice if you could provide some more information about that.

-Jens Suessmeyer.

http://www.sqlserver2005.de

|||SQL Server backend with Access VBA code|||

Hi,

sorry for picking up your issue this late, but sometime posts get out of sight in my mailbox and the weekend is preferable my time to pick them all up. Have a look at some sample code here:

http://www.freevbcode.com/ShowCode.Asp?ID=1802

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

IIS Logs Max Per Hour

Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Quote:

Originally posted by Simon Jelinek
Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Try asking your manager, I hear he is very good at this sort of thing