Eli Leiba

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.

All authors

TSQL that lists all numbers from 1..100

by Eli Leiba

SQLServerCentral.com

CROSS JOIN

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.38 (13)

You rated this post out of 5. Change rating

2012-02-20 (first published: 2011-12-31)

2,156 reads

Discuss

Get the #lines in a TSQL view/SP/UDF of a String

by Eli Leiba

SQLServerCentral

T-SQL

The following procedure gets a TSQL program object(View/UDF/stored procedure) and a given stringIt searched object's source code for the string and returns the number of lines where a match is found.This is helpful when we want to search all our TSQL code for a specific table name, column etc. and investigate where it is referenced […]