SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table DataTable (dt1 int, dt2 nvarchar(10), cp1 int)
insert into DataTable (dt1, dt2) values (0, '1'), (0, '1ABC'), (0, null)
3 rows affected

select * from DataTable


dt1
dt2
cp1


0
1
null

0
1ABC
null

0
null
null


exec sp_executesql 
	N'select * From DataTable WHERE DT1 = @P1 AND DT2 = @P2 order by cp1',
	N'@P1 int, @P2 int', 1, 10


dt1
dt2
cp1


exec sp_executesql 
	N'select * From DataTable WHERE DT1 = @P1 AND DT2 = @P2 order by cp1',
	N'@P1 int, @P2 int', 0, 10
Msg 245 Level 16 State 1 Line 1
Conversion failed when converting the nvarchar value '1ABC' to data type int.

exec sp_executesql 
	N'select * From DataTable WHERE DT1 = @P1 AND DT2 = @P2 order by cp1',
	N'@P1 int, @P2 nvarchar(10)', 0, '10'


dt1
dt2
cp1

dt1	dt2	cp1
0	1	null
0	1ABC	null
0	null	null