Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Eli Leiba

SQLServerCentral.com profile

Eli Leiba works at Israel Electric Company as a Senior Application DBA in Oracle and MS SQL Server. He also has certifications from Microsoft and BrainBench in Oracle and SQL Server database administration and implementation. Mr. Leiba holds a B.S. in Computer Science since 1991 and has 13 years experience working in the databases field. Additionally Mr. Leiba teaches SQL Server DBA and Development courses at Microsoft CTEC and also serves as a senior database consultant for several Israeli start-up companies.

   Items 1 to 2 of 2   
 

TSQL that lists all numbers from 1..100

This query shows how to write a T-SQL statement that lists all numbers between 1 and 100 ordered, without use of any DATABASE table with only ONE select statement.  Read more...
By Eli Leiba 2012/02/20 | Source: SQLServerCentral.com | Category: cross join
Rating: |  Discuss |   Briefcase | 1,997 reads
   Items 1 to 2 of 2