Showing posts with label regards. Show all posts
Showing posts with label regards. 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

Tuesday, March 27, 2012

Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

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
>