Monthly Archives: February 2010

Remove a table manually from SLOX

Posted on February 23, 2010 by

drop table YourTableName delete from sectabledefs where tablename = ‘YourTableName’ delete from joindata where fromtable = ‘YourTableName’ or totable = ‘YourTableName’ delete from resynctabledefs where tablename = ‘YourTableName’ ======================= Caution: Deleting a column through the Architect will also remove any … Continue reading →

Posted in SalesLogix | Leave a comment

Tricks using Full Text Search with Chinese content

Posted on February 10, 2010 by

SQL Full Text Search offers a fuzz logic search. To get desired search result with Chinese content, the following steps have to be followed (among others): Set language for columns (and you can’t mix different language settings for a table): … Continue reading →

Posted in ASP.NET, SQL | Tagged | Leave a comment

Using Full Text Search with LINQ

Posted on February 10, 2010 by

LINQ does not natively support full text search keywords (FREETEXT, CONTAINS etc).  Actually the compiler won’t complain about them but just translate everything to LIKE. Here is the work around: 1. Create a table-valued function that takes in keyword as … Continue reading →

Posted in ASP.NET, SQL | Tagged | Leave a comment

Sleep in TSQL

Posted on February 9, 2010 by

Sleep for 30 seconds: WAITFOR DELAY ’00:00:30′

Posted in SQL | Tagged | Leave a comment