how to insert images...

Complete SQL newbie here.......running SQL 2k.
I created a datatype called 'Picture' of type Image using Enterprise
Manager's Design Table function.
My question, how can I specify what the image is for a given table
row/entry? For text data types I can just type in what I want the
value to be.
Most answers I've seen talk about running scripts to do inserts.
There's got to be a drag 'n drop or File/Open type way of doing this.
I mean I remember watching people do this with a database app on a
NextStation way back when (drag n drop).....you'd think the mighty
SQL Server 2000 would have similiar abilities.
Any help appreciated.
J.Sorry, SQL Server isn't a WYSIWYG editor, and there is no drag 'n' drop
interface.
In most situations, it's probably not a good idea to store an image in your
database anyway... See for more info:
http://www.aspfaq.com/show.asp?id=2149
"James" <lee.james@.spartan.ab.ca> wrote in message
news:17084052.0403121132.1aa413a7@.posting.google.com...
> Complete SQL newbie here.......running SQL 2k.
> I created a datatype called 'Picture' of type Image using Enterprise
> Manager's Design Table function.
> My question, how can I specify what the image is for a given table
> row/entry? For text data types I can just type in what I want the
> value to be.
> Most answers I've seen talk about running scripts to do inserts.
> There's got to be a drag 'n drop or File/Open type way of doing this.
> I mean I remember watching people do this with a database app on a
> NextStation way back when (drag n drop).....you'd think the mighty
> SQL Server 2000 would have similiar abilities.
> Any help appreciated.
> J.|||Hi James,
I am reviewing you post and since we have not heard from you for some time
in the newsgroup, I wonder if our community member's information is helpful
to your question. For any more question, please post your message here and
we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql

How to implement a data base design for multi language support?

Hi,
I have searched the web for several hours now to find a reference solution
based on the available features of Sql Server 2005 to implement a data base
with multi language support.
I would like to create a database that is able to store multiple
translations (text in different languages) for the same original value.
--> tblProducts, Field ProductDescription --> One field, manny languages
If I query this table/field with a current UI-Culture from
ASP.net/WindowsForms it should be 'intelligent' and return the value based on
the UI-Culture. It should work like the culture stuff in the GUI...
I am lookig for a solution, where I can store all the language relevant
informations in the same field. Do I have to use an XML-field or a user
defined field? Is there something like a "best practise" for this kind of
database design available?
I would like to avoid a 1 to many relation for all culture relevant fields
in my database...
Thanks for any hint,
DirkAt previous company i worked at they had multi language support and
they used what was like a codes table. w/ a language type ID
associated w/ all the words on the various pages. depending on the
language type code it would pull in the words to the page. so they
just stored 10 differenet sets of language codes in the db. they
brought it in fresh everytime w/ a select statement.|||Hi Thomas,
thanks for your reply. I'm sure this approch works but I would like to make
it easier. With your solution I have to join the tables every time I need a
lagnuage relevant value.
I was thinking about using the Sql Server 2005 FieldType 'xml' and store a
xml strcture in every relevant field like
<values>
<value culture='en-us'>
car
</value>
<value culture='de-de'>
Auto
</value>
</values>
I just want to hear some solution from others just to make it no so
complicated...
Thanx,
Dirk

How to implement a data base design for multi language support?

Hi,
I have searched the web for several hours now to find a reference solution
based on the available features of Sql Server 2005 to implement a data base
with multi language support.
I would like to create a database that is able to store multiple
translations (text in different languages) for the same original value.
--> tblProducts, Field ProductDescription --> One field, manny languages
If I query this table/field with a current UI-Culture from
ASP.net/WindowsForms it should be 'intelligent' and return the value based o
n
the UI-Culture. It should work like the culture stuff in the GUI...
I am lookig for a solution, where I can store all the language relevant
informations in the same field. Do I have to use an XML-field or a user
defined field? Is there something like a "best practise" for this kind of
database design available?
I would like to avoid a 1 to many relation for all culture relevant fields
in my database...
Thanks for any hint,
DirkAt previous company i worked at they had multi language support and
they used what was like a codes table. w/ a language type ID
associated w/ all the words on the various pages. depending on the
language type code it would pull in the words to the page. so they
just stored 10 differenet sets of language codes in the db. they
brought it in fresh everytime w/ a select statement.

How to implement a data base design for multi language support?

Hi,
I have searched the web for several hours now to find a reference solution
based on the available features of Sql Server 2005 to implement a data base
with multi language support.
I would like to create a database that is able to store multiple
translations (text in different languages) for the same original value.
--> tblProducts, Field ProductDescription --> One field, manny languages
If I query this table/field with a current UI-Culture from
ASP.net/WindowsForms it should be 'intelligent' and return the value based on
the UI-Culture. It should work like the culture stuff in the GUI...
I am lookig for a solution, where I can store all the language relevant
informations in the same field. Do I have to use an XML-field or a user
defined field? Is there something like a "best practise" for this kind of
database design available?
I would like to avoid a 1 to many relation for all culture relevant fields
in my database...
Thanks for any hint,
Dirk
At previous company i worked at they had multi language support and
they used what was like a codes table. w/ a language type ID
associated w/ all the words on the various pages. depending on the
language type code it would pull in the words to the page. so they
just stored 10 differenet sets of language codes in the db. they
brought it in fresh everytime w/ a select statement.