12 – The Problem with Multi-Parameter Stored Procedures (21m)

Everybody wants the same thing: a stored procedure that has multiple parameters, and lets you search by any combination of values. Say we’re looking at the Stack Overflow Users table, and we want to search people by DisplayName, Location, and/or Reputation – we might want a proc that works like this: Transact-SQL EXEC usp_SearchUsers @SearchDisplayName…