Aliasing Problem In SQL Query

[Simon_Whale]

Select S_no as [S. No.] From Emp;

would work but as Luc said that its not best practice.

As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

[Lost User]

It's Not working..............

If you can think then I Can.

[Simon_Whale]

what sort of error message did you get?

As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

[Lost User]

Error is :

Invalid bracketing on name 'S. No.'.

If you can think then I Can.

[Simon_Whale]

try

select columnName as S_NO from tablename

As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

[Mycroft Holmes]

You're real problem is that you are putting UI information into the query, this type of formatting belongs in your user interface no the database Oh and this does work in sql server 2005/08

SELECT ship [S. No.] FROM Ship AS S

Never underestimate the power of human stupidity RAH

[Wendelius]

Try adding quotation marks around the alias:

Select S_no AS "S. No." From Emp;

The need to optimize rises from a bad design.My articles[^]

[venkynataraj]

In SQL query '.' can be used to get a column from a table... For eg : "Select Employee.EmpId from Employee" So Sql always expects a column name after a '.' , use some other characters as alias names. This would solve your problem

[Prasanta_Prince]

Use a valid identifier. Dot is not a valid identifier.

[Lost User]

read complete summery of this question. Do't waste your time in Closed Questions.

If you can think then I Can.