Monthly Archives: February 2010

Remove a table manually from SLOX

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

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

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

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

Posted in SQL | Tagged | Leave a comment