select sysobjects.name, syscolumns.name from syscolumns left join sysobjects on sysobjects.id = syscolumns.id where syscolumns.name like '%guid%' order by 1,2
select sysobjects.name, syscolumns.name
from syscolumns
where syscolumns.name like '%guid%'
order by 1,2
I am the owner of Stagich Software Consulting. Stagich Software Consulting specializes in developing Microsoft .Net/Microsoft SQL software applications.
Get notified when a new post is published.
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
Sign In