The sql data type conversion problem is urgent! ~

magiccici

create proc Search_Data
@Detail varchar (255),
@Address varchar (255),
@DAMode int
as
if @ Detail = '' set @ Detail = null
if @ Address = '' set @ Address = null
if @ DAMode = '' set @ DAMode = null
select * from DADevice
where Detail like '%' + isnull (@ Detail, Detail) + '%'
and Address like '%' + isnull (@ Address, Address) + '%'
and @DAMode like '%' + isnull (@ DAMode, DAMode) + '%'

This is a stored procedure that can be generated, but the error is:
Server: Message 245, Level 16, State 1, Process Search_Data, Line 9
A syntax error occurred while converting the varchar value '%' to a column of data type int.

Then help the boss, I ca n’t turn around! ~ Thank you! ~

llz_27

declare @damode varchar(50)

...
and @DAMode like'%'+cast(isnull(@DAMode,DAMode) as varchar(50) )+'%'

cv4bf5d65fd

@DAMode int This defines an integer

cv4bf5d65fd

create proc Search_Data
@Detail varchar(255),
@Address varchar(255),
@DAMode varchar(255)
as
if @Detail='' set @Detail=null
if @Address='' set @Address=null
if @DAMode='' set @DAMode=null
select * from DADevice
where Detail like'%'+isnull(@Detail,Detail)+'%'
and Address like'%'+isnull(@Address,Address)+'%'
and @DAMode like'%'+isnull(@DA Mode,DAMode)+'%'