Parametrize the WHERE clause?
- by ControlFlow
Hi, stackoverflow!
I'm need to write an stored procedure for SQL Server 2008 for performing some huge select query and I need filter it results with specifying filtering type via procedure's parameters (parameterize where clause). I found some solutions like this:
create table Foo(
id bigint, code char, name nvarchar(max))
go
insert into Foo…