Creating a flexible SQL search stored procedure

by Matthias Broschk August 16, 2008 15:16
Today I am going to deal with a fairly common problem. You have a search form with a number of n fields, of which most or even all are optional. That means in the worst case there are n² (empty or not) possible combinations. Classic static SQL seems to be a problem, so the most obvious solution would be a SQL string that is dynamically generated within your program code. But since you rather ... [More]

Tags: , ,

Visual Basic.NET | SQL Server

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen | Modified by Mooglegiant

About the author

Matthias Broschk from Hamburg (Germany) wrote his first goto statements in QuickBasic at the age of fifteen, switched to Visual Studio (i.e. Visual Basic / Visual C++) at version 5.0 and has been an addict of .NET since its early beginnings. There have been many other languages and frameworks (Java, PHP, ... ), but none about which he has been as enthusiastic as .NET. These days you can find more information in blogs rather than anywhere else. Therefore he has decided to share his experiences and start yet another .NET blog.