EdwardPeter
asked on
Syntax error converting the varchar value
Kindly assist on the error, Thanks.
Server: Msg 245, Level 16, State 1, Procedure SP_operator_name, Line 6
Syntax error converting the varchar value 'Victor DeGuia' to a column of data type int.
create proc dbo.SP_operator_name
@operatorid int
as
declare @operatorname as varchar(100)
select @operatorname=operatorname from operator_master where operatorid=@operatorid
return @operatorname
Go
exec itpbilling.SP_operator_nam e @operatorid=2011
Server: Msg 245, Level 16, State 1, Procedure SP_operator_name, Line 6
Syntax error converting the varchar value 'Victor DeGuia' to a column of data type int.
create proc dbo.SP_operator_name
@operatorid int
as
declare @operatorname as varchar(100)
select @operatorname=operatorname
return @operatorname
Go
exec itpbilling.SP_operator_nam
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.