How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query

by

If You are using SQL Server 2008 

select VersionNo from Versions order by cast("https://stackoverflow.com/" + replace(VersionNo , '.', "https://stackoverflow.com/") + "https://stackoverflow.com/" as hierarchyid);

What is hierarchyid

Edit:

Solutions for 2000, 2005, 2008: Solutions to T-SQL Sorting Challenge here.

The challenge

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. How to Join to first row
  3. Pivot using SQL Server 2000
  4. How to get the first and last date of the current year?
  5. Perform regex (replace) in an SQL query
  6. WHERE IS NULL, IS NOT NULL or NO WHERE clause depending on SQL Server parameter value
  7. Find last sunday
  8. How do I escape a single quote in SQL Server?
  9. NOT IN vs NOT EXISTS
  10. Only inserting a row if it’s not already there
  11. Unpivot with column name
  12. Selecting data from two different servers in SQL Server
  13. Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?
  14. How to convert DateTime to VarChar
  15. Most efficient way in SQL Server to get date from date+time?
  16. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  17. Stored Procedure with optional “WHERE” parameters
  18. SQL Server: Howto get foreign key reference from information_schema?
  19. SCOPE_IDENTITY() for GUIDs?
  20. How do I perform a GROUP BY on an aliased column in SQL Server?
  21. How do you import a large MS SQL .sql file?
  22. Difference between Subquery and Correlated Subquery
  23. How to execute .sql file using powershell?
  24. How to write UPDATE SQL with Table alias in SQL Server 2008?
  25. Restrict an SQL Server connection to a specific IP address
  26. Getting Dates between a range of dates
  27. Can SQL Server Express LocalDB be connected to remotely?
  28. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  29. SQL SERVER DATETIME FORMAT
  30. Insert all values of a table into another table in SQL

Leave a Comment