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
November 20. 2009 11:46
Hrmm that was weird, my comment got eaten. Anyway I wanted to say that it's nice to know that someone else also mentioned this as I had trouble finding the same info elsewhere. This was the first place that told me the answer. Thanks.
homemade colon cleanse
November 21. 2009 18:48
I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol
send flower malaysia
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