Dynamic result ordering in SQL Submitted by st on Tue, 18/05/2010 - 17:19 There are several methods to implement the dynamic ordering of result returned by SQL query. The examples of stored procedures below use the Microsoft's demo database AdventureWorks. USE AdventureWorks GOProgrammingSQL Server Read more about Dynamic result ordering in SQLst's blogAdd new comment3224 readsFrançais
Random sequence in Transact SQL query Submitted by st on Sat, 04/07/2009 - 13:07 The rand() Transact SQL function produces a sequence of same numbers in the query. For example:ProgrammingSQL Server Read more about Random sequence in Transact SQL queryst's blogAdd new comment3469 readsРусскийFrançais
SQL Server: show size of tables Submitted by st on Thu, 25/06/2009 - 01:25 How much of disk space is used by tables? ProgrammingSQL Server Read more about SQL Server: show size of tablesst's blogAdd new comment2603 readsРусскийFrançais