Gaby Abed (2/27/2009)

---

How many rows would this return? 🙂 (yes...it's different)

use AdventureWorks

go

declare @tableA TABLE(col1 int, col2 int)

go

--stmt 1

select name from tempdb.sys.tables where name like '%tableA%'

--stmt 2

select name from tempdb.sys.columns where name like 'col1%'