Create Static Records in SELECT

[RichardParry]

Hi,

I was wondering how I can get data from a standard DB Table in the SELECT as per normal, but also set a column to static data, defined in the SELECT? I can do this in Access 2000 with SELECT MadeUpFieldColumn: "Repeat Data Here", Table.NormalField FROM Table

This works great in Access, but SQL 2000 won't allow it. Is there any way to do this in SQL (I am using a View)?


Thanx! Richard

 

[gmmastros]

Sure. It would look something like this...

Select Column1, 
       Column2,
       [!]'My Hardcoded Data' as ColumnAlias[/!]
From   TableName

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[RichardParry]

Ah, Thank you George! I was trying it with quotes and not apostrophes Thanx!

 

[gmmastros]

I don't think there is a single occasion to use the quote symbol in a query. Anywhere. In fact... grab a screwdriver (or similar prying instrument) and remove that key from your keyboard. Your queries will thank you.

Of course, using quotes will sometimes work, but your better off doing it another way.

For example....

Select 1 As "Whatever Column Alias You Want"

This will work, but the preferred method is...

Select 1 As [Whatever Column Alias You Want]

Use the square brackets instead.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLDenis]

you forgot one

Select 1 As 'Whatever Column Alias You Want'

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions