T-SQL – Aliasing using “=” versus “as” [closed]

by

‘=’ isn’t valid ANSI SQL, so you’ll have difficulty should you wish to run your application on a different DBMS.

(It’s when ANSI form is used but the optional ‘AS’ is omitted I find the results difficult to read, personally.)

More Related Contents:

  1. Calculate a Running Total in SQL Server
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. Not equal != operator on NULL
  4. SET NOCOUNT ON usage
  5. How can I get column names from a table in SQL Server?
  6. How can I select the first day of a month in SQL?
  7. Subquery using Exists 1 or Exists *
  8. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  9. Is it possible to specify condition in Count()?
  10. Update records in table from CTE
  11. Selecting N rows in SQL Server
  12. how can I Update top 100 records in sql server
  13. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  14. How can I INSERT data into two tables simultaneously in SQL Server?
  15. How can a LEFT OUTER JOIN return more records than exist in the left table?
  16. Count Number of Consecutive Occurrence of values in Table
  17. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  18. Pivot data in T-SQL
  19. Column name or number of supplied values does not match table definition
  20. Split one column value into multiple column values
  21. Get the records of last month in SQL server
  22. Merge overlapping date intervals
  23. I want to use CASE statement to update some records in sql server 2005
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. alternatives to REPLACE on a text or ntext datatype
  26. SQL poor stored procedure execution plan performance – parameter sniffing
  27. How to return a incremental group number per group in SQL
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment