[dba-SQLServer] Does view support column alias?

Susan Harkins ssharkins at gmail.com
Mon Feb 23 13:18:40 CST 2009


That's the result I got too Francisco -- I'm wondering now what put that 
idea into my head -- it obviously is incorrect. Thanks for verifying it!

Susan H.


> Within the view... you'll need to write it as:
> CREATE VIEW
> FROM transactions
> SELECT id, quantity * cost AS [Total Cost]
> WHERE quantity * cost > 100




More information about the dba-SQLServer mailing list