tag:blogger.com,1999:blog-3924739636407907202.post3321284787309105725..comments2023-10-07T05:59:41.036-03:00Comments on HunabKu: The art to invent: MsSQL’s artistsFabio Maulohttp://www.blogger.com/profile/13558454874302740335noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3924739636407907202.post-53296455407600654102009-07-08T20:27:47.086-03:002009-07-08T20:27:47.086-03:00an ugly workaround would be
select name from mytab...an ugly workaround would be<br />select name from mytable<br />where <br /> (case when contains(name,'something') then '1' <br /> else '0' end)='1'Unknownhttps://www.blogger.com/profile/03951021615819510917noreply@blogger.comtag:blogger.com,1999:blog-3924739636407907202.post-6442558661165973782009-07-05T10:55:01.743-03:002009-07-05T10:55:01.743-03:00(a typo in my comment without any intention: guy)....(a typo in my comment without any intention: guy).Joséhttps://www.blogger.com/profile/00939999997597980426noreply@blogger.comtag:blogger.com,1999:blog-3924739636407907202.post-15900720141085215222009-07-05T10:53:30.464-03:002009-07-05T10:53:30.464-03:00It seems that the gay responsible for this functio...It seems that the gay responsible for this function was in his own world.. <br /><br />Contains( column, ' "thing" or "other thing" ')<br /><br />WTF?!?!<br />should be:<br /><br />Contains (column, 'thing') or contains(column, 'otherthing')<br /><br />For sure he was trying to invent "delegates" under tsql.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3924739636407907202.post-55306502436791273302009-07-05T10:34:00.797-03:002009-07-05T10:34:00.797-03:00Probably you don't know how you should write a...Probably you don't know how you should write a paginate query in MsSQL2005. Try to write a normal SQL with an order-by and then paginate it.<br />About the two function, as I said, they aren't returning boolean.Fabio Maulohttps://www.blogger.com/profile/13558454874302740335noreply@blogger.comtag:blogger.com,1999:blog-3924739636407907202.post-52546590647880687752009-07-05T04:08:35.622-03:002009-07-05T04:08:35.622-03:00It is really heavy. So heavy, that i actually did ...It is really heavy. So heavy, that i actually did not grasp the point of what is wrong with pagination and what are the returns values (isn't it boolean?)Darius Damalakashttps://www.blogger.com/profile/04596650719650364667noreply@blogger.com