I have a Stored Pro that accepts gender argument. It is like
ALTER PROCEDURE [dbo].[dslmsSP_memberReportsLists]
-- Add the parameters for the stored procedure here
@gender varchar(1)='',
AS
DECLARE @runsql varchar(4000)='SELECT DISTINCT studentidcard,firstname from tblstudents'
DECLARE @limits varchar(4000)=''
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- add limits now
IF @gender<>''
SET @limits=@limits + ' sex=' + CHAR(39) + @gender + CHAR(39)
-- DO WE NEED TO LIMIT STUFF OR NOT?
if @limits<>''
BEGIN
SET @runsql=@runsql + ' WHERE ' + @limits
END
-- exectue statement
EXEC (@runsql)
return @@ERROR
[/CODE]
When I run it, gives the following error:
Msg 245, Level 16, State 1, Procedure dslmsSP_memberReportsLists, Line 113
Conversion failed when converting the varchar value ' sex='M' ' to data type int.
I dont want it to be converted to int at all nor I have casted anywhere. It is drivin me really crazy..anyone can spot the source please? The error is raised if I pass gender argument only.
All guys!
SS converting varchar to int on its own...
Posted - 04/30/2012 : 07:05:31
