Hi,
I use VARCHAR(MAX) for parameters (Not for fields), These parameters are used in the Where clause of the Query.
for example.
CREATE PROCEDURE [Sample]
(
@deliverycenter varchar(500)
)
as
declare
select * from itemdetails i where i.deliverycentercd in (@deliverycenter)
.....
Here instead of using varchar(500) can I use VARCHAR(Max), does it affects the performance.