March 25, 2008 at 5:40 pm
Ok, I know that the best way to do this is either a) before the data goes into the DB or b) using the functions of the front end application, however; I have a column in a table that is all upper case because it was built from a list of tables in the DB. I also want a column in the same table to have an alias for the table names, so "REPLACEMENT_HOME" will be "Replacement Home" in the alias column. Anyone have a script that does this, or advice on the best way to make this conversion in a speedy (and reusable) method?
Thanks in advance...
Brad
March 25, 2008 at 5:58 pm
Considering there's a function to do that in .NET - I'd build a CLR function to handle it.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 25, 2008 at 6:04 pm
Thanks, Matt..I'll look at doing it that way, after a quick read on CLR functions.
Ciao...
Brad
March 26, 2008 at 9:38 am
Here's a follow-on question - if the DB is ported to Oracle 10g will the same type of function still work, or is that something only available when using SQL Server? This solution I'm working on needs to be able to be used with "any database"...but the main focus is SQL Server and Oracle 10g right now.
Brad
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply