469,106 Members | 2,289 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

getting english column names into a german database

I'm currently implementing a German ERP system and I'm having a
terrible time writing reports/SQL statements. The database is MS SQL
Server 2000. I want to set permanant aliases for the columns that I
can use in SQL statements. Is this even possible? All of the research
I've done implies that you can only alias column names in the output of
a SQL statement.

Jul 23 '05 #1
2 1065
You can create a view, 'en_tablename' for each table and select and alias
all the columns to something a little more helpful, then use the views in
all your queries instead of the base tables.

Regards
Mr Tea

"o0fragility0o" <hy******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I'm currently implementing a German ERP system and I'm having a
terrible time writing reports/SQL statements. The database is MS SQL
Server 2000. I want to set permanant aliases for the columns that I
can use in SQL statements. Is this even possible? All of the research
I've done implies that you can only alias column names in the output of
a SQL statement.

Jul 23 '05 #2
Thanks, great idea.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

66 posts views Thread by jacob navia | last post: by
1 post views Thread by Eric | last post: by
reply views Thread by news.online.de | last post: by
1 post views Thread by jackal_on_work | last post: by
1 post views Thread by sajithamol | last post: by
7 posts views Thread by The Bicycling Guitarist | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.