Alias name is same as column name [closed]

by

You have aliased two columns as published.

a.published,

and

CASE a.type
WHEN N'component' THEN a.published+2*(e.enabled-1)
WHEN N'url' THEN a.published+2
WHEN N'alias' THEN a.published+4
WHEN N'separator' THEN a.published+6 END AS published,

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  3. How can I escape square brackets in a LIKE clause?
  4. Parameter Sniffing (or Spoofing) in SQL Server
  5. How can I truncate a datetime in SQL Server?
  6. What are the main performance differences between varchar and nvarchar SQL Server data types?
  7. Datatype for storing ip address in SQL Server
  8. SQL Server: Query fast, but slow from procedure
  9. Is there a way to loop through a table variable in TSQL without using a cursor?
  10. sql server invalid object name – but tables are listed in SSMS tables list
  11. Concatenating Column Values into a Comma-Separated List
  12. What columns generally make good indexes?
  13. List the queries running on SQL Server
  14. SQL Server Bulk insert of CSV file with inconsistent quotes
  15. What is a free tool to compare two SQL Server Databases? [closed]
  16. SQL Server Query: Fast with Literal but Slow with Variable
  17. How can I make HTTP request from SQL server?
  18. SQL Server Management Studio alternatives to browse/edit tables and run queries [closed]
  19. Format SQL in SQL Server Management Studio
  20. SQL Server, the misleading XLOCK & optimizations
  21. #DELETE viewing SQL Server table in Access
  22. Grant Select on a view not base table when base table is in a different database
  23. SQL Server (localdb)\v11.0 explained
  24. migrate data from MS SQL to PostgreSQL?
  25. SQL Server – join rows into comma separated list
  26. SQL Server 2008 can’t login with newly created user
  27. Update SQL with consecutive numbering
  28. Nested transactions in Sql Server
  29. What is the difference between Cartesian product and cross join?
  30. Count number of records returned by group by

Leave a Comment