COLUMN_NAME to PASCAL CASE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

COLUMN_NAME to PASCAL CASE

Author

Topic

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2008-05-02 : 12:22:11

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-05-02 : 12:48:07

select column1 as alias1, column2 as alias2, etc ...
from yourtable

- Jeff
http://weblogs.sqlteam.com/JeffS

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2008-05-02 : 14:41:56

Not this....,

I am creating a .net class using each database table.
like this

INSERT INTO @temp
SELECT 5, '#region Private Fields' + CHAR(13) + CHAR(10)
INSERT INTO @temp
SELECT 6, CHAR(9) + 'private ' +
CASE
WHEN DATA_TYPE LIKE '%CHAR%' THEN 'string '
WHEN DATA_TYPE LIKE '%INT%' THEN 'int '
WHEN DATA_TYPE LIKE '%DATETIME%' THEN 'DateTime '
WHEN DATA_TYPE LIKE '%BINARY%' THEN 'byte[] '
WHEN DATA_TYPE = 'BIT' THEN 'bool '
WHEN DATA_TYPE LIKE '%TEXT%' THEN 'string '
ELSE 'object '
END + '_' + COLUMN_NAME + ';' + CHAR(9)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @table_name
ORDER BY ORDINAL_POSITION

Here I need to change COLUMN_NAME to Pascal

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-02 : 14:50:21

I guess you're asking for column names in proper case. Have a look at function in this link

http://weblogs.sqlteam.com/jeffs/archive/2007/03/09/60131.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources