Even with the best of intentions, it is possible to find oneself searching whole blocks of text in a database, or searching across columns. The first type of search I’ll refer to is the ‘Brute-force’ search, where performance isn’t the primary concern. This article is about some of the SQL magic that might be required. Just occasionally, usually when you’re searching through text, or you’ve inherited the work of someone whose major talents lie in other areas of life, you need other magic. Searching for Strings in SQL Server Databases - Simple Talkįor most of the time you will get adequate powerful searches from a well-normalized database that has all possible constraints and indexes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |