Adding Units and Displaying Photo

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Adding Units and Displaying Photo

Author

Topic

Leonzc
Starting Member

5 Posts

Posted - 2008-11-17 : 08:31:20

Hi, could any one teach me how to add units to the back of the result?

Example:

From

Interval
11
20
30

To

Interval
11 min
20 min
30 min

and also how to add location to the query result so as to display an image

Example :

instead of just words i would like to display the image itself.
image is stored in C:/document/imagefolder

Image
Photo1.Img
Photo2.Img
Photo3.Img

i would like the image to be shown out. any idea guys?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-11-17 : 09:09:38

Assume Interval is a numeric type in a table:

select convert(varchar(10),Interval)+' min' as Interval from yourTable

But:
to display images is not the job of sql - do it in your front end application.

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-17 : 09:44:49

whats the datatype of actual field?

Leonzc
Starting Member

5 Posts

Posted - 2008-11-17 : 19:46:33

my picture is saved under "text" type, as webfred had said, it should be under visual studio C# coding, i will try working on it before approaching you guys again. Thx alot ya =)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources