Link to home
Start Free TrialLog in
Avatar of EdwardPeter
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_name @operatorid=2011
ASKER CERTIFIED SOLUTION
Avatar of BillAn1
BillAn1

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial