Programming

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
GO

Programming

SQL Server

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:

Programming

SQL Server

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?

Programming

SQL Server

Programming

Dynamic result ordering in SQL

Random sequence in Transact SQL query

SQL Server: show size of tables

Pages

Tags

Search form

Pages

User login

Tags