473,387 Members | 1,550 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 1115
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Andreas Emmert | last post by:
Hi there, I'm trying to import a csv file into my MySQL database. Unfortunately the number format for the price column is formatted in German style, i.e. XX,XX (decimals separated by comma not...
3
by: F. GEIGER | last post by:
When I start a py2exe-ed application I get the error 'ascii' codec can't encode character u'\xe9' in position 10: ordinal not in range(128) This is how I run py2exe: setup.py py2exe -O1...
66
by: jacob navia | last post by:
The english word "Initialized" exists. (Cambridge dictionary finds it). The word "Uninitialized" doesn't seem to exist, and no dictionary has it. I am using that word very often in my tutorial of...
1
by: Eric | last post by:
Hi, Normally I'm developing evertime with the english versions of Win, VS.NET, ..NET etc. But know I have a german Win XP SP1 with IIS 5.1 installed. Anyway I would like to develop with...
0
by: news.online.de | last post by:
Hello everybody, probably it's a FAQ but I didn't find anything so far concerning my problem, so I am asking here :-) I am facing the following problem: - I have developed a webservice client...
1
by: jackal_on_work | last post by:
Hi, I have a database and want to store data in Spanish and English. To accompish this: 1. Do i need to create separate tables for both the languages like items_en and items_sp? 2. If I opt...
1
by: sajithamol | last post by:
Hi, I have a table TABLE1 which contains a column "name" that has to be matched with the column "name" of another table TABLE2, but the problem is that column "name" of TABLE1 contains values with...
7
by: The Bicycling Guitarist | last post by:
If I have a foreign word, name or phrase in one of my pages, I use the lang attribute to specify the relevant language, e.g., <span lang="de">Manfred von Richthofen</span>. But what if I want to...
3
by: koti688 | last post by:
how to get the column names and the values of them in select statment. I have a packaze like this named ADB.pm package ADB; use DBI; @ISA = ('Exporter');
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.