sql server failed to find the stored procedure

zuoshou

My stored procedure is like this
CREATE PROCEDURE GetCardByNumber
@CardNumber nvarchar(255)
AS
DECLARE @sql NVARCHAR(2000)

   set @CardNumber ='''' + replace(@CardNumber,'.',''',''') +''''

SET @sql ='select * from CardTable where CardNumber in ('+ @CardNumber +')'
exec @sql
GO

When I run it, I get an error: Cannot find the stored procedure'select * from CardTable where CardNumber in ('226026275526')'.

Please help analyze the error. Thank you

德鲁伊

226026275526--Do you know what this is?

shenmue024

exec @sql

====>
exec (@sql)

德鲁伊

set @CardNumber =replace(@CardNumber,'.',',')
SET @sql ='select * from CardTable where CardNumber in (‘’' + @CardNumber +'‘’)'
exec @sql

德鲁伊

I'm wrong, sorry

zuoshou

set @CardNumber =replace(@CardNumber,'.',',')
SET @sql ='select * from CardTable where CardNumber in (‘’' + @CardNumber +'‘’)'
exec @sql

Still not working, unable to find the stored procedure'select * from CardTable where CardNumber in (''888574781435'')'.

zuoshou

exec @sql

====>
exec (@sql)
Can you elaborate on what it means, I don’t understand

zuoshou

No data can be found after using this exec (@sql)

德鲁伊

You execute the @sql statement, the correct way is exec(@sql)

zuoshou

My select statement is ok