Showing posts with label guide. Show all posts
Showing posts with label guide. Show all posts

Thursday, March 29, 2012

Database image on report

Hi,

How to display image stored in the database into sql server report?

Please guide.

Thank you,

Regards,

Prashant

Please read this RS BOL topic: http://msdn2.microsoft.com/en-us/library/ms156342(SQL.90).aspx

Particularly read the comment near the top if the images came originally from an Access database, because in that case the actual image data is an OLE image and you have to write an expression to remove the OLE image header from the data.

-- Robert

Sunday, February 19, 2012

Database design

How do I get my Database Design, my manager told me that there is an
option for the same to create it....
Is there any?
Please guide........
Regards,
Amit AroraScript?
select ordinal_position 'Seq',
cast(column_name as varchar(40)) 'Column',
isnull(character_maximum_length, numeric_precision) 'Size',
cast(data_type as varchar(12)) 'Type'
from information_schema.columns
where table_name = 'tests'
http://www.databaseanswers.com/data_models/index.htm -- examples
database design
<aroraamit81@.gmail.com> wrote in message
news:1147263655.365843.215460@.j73g2000cwa.googlegroups.com...
> How do I get my Database Design, my manager told me that there is an
> option for the same to create it....
> Is there any?
> Please guide........
> Regards,
> Amit Arora
>|||Nopes just needed the way to export my database deisgn, like you have
design diagram, so that I can show it to my manager
Thanks,
Amit Arora|||Print it?
<aroraamit81@.gmail.com> wrote in message
news:1147264818.029433.201190@.j33g2000cwa.googlegroups.com...
> Nopes just needed the way to export my database deisgn, like you have
> design diagram, so that I can show it to my manager
> Thanks,
> Amit Arora
>

Database design

How do I get my Database Design, my manager told me that there is an
option for the same to create it....
Is there any?
Please guide........
Regards,
Amit AroraScript?
select ordinal_position 'Seq',
cast(column_name as varchar(40)) 'Column',
isnull(character_maximum_length, numeric_precision) 'Size',
cast(data_type as varchar(12)) 'Type'
from information_schema.columns
where table_name = 'tests'
http://www.databaseanswers.com/data_models/index.htm -- examples
database design
<aroraamit81@.gmail.com> wrote in message
news:1147263655.365843.215460@.j73g2000cwa.googlegroups.com...
> How do I get my Database Design, my manager told me that there is an
> option for the same to create it....
> Is there any?
> Please guide........
> Regards,
> Amit Arora
>|||Nopes just needed the way to export my database deisgn, like you have
design diagram, so that I can show it to my manager
Thanks,
Amit Arora|||Print it?
<aroraamit81@.gmail.com> wrote in message
news:1147264818.029433.201190@.j33g2000cwa.googlegroups.com...
> Nopes just needed the way to export my database deisgn, like you have
> design diagram, so that I can show it to my manager
> Thanks,
> Amit Arora
>