Codekeep.net has a great stored-proc-free code snippet for text searching SQL Server database columns.
Unfortunately this code fails due to single quotes in the column names of the database I'm working with (I know I know, don't get me started!)
It's a simple fix.
On line 43, replace
@ColumnName
with
replace(@ColumnName,'''','')
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment