I have a sp like this
ALTER PROCEDURE [dbo].[st_test] @SelectString as varchar(8000)
ORDER BY userid
When I exec this sp
exec [st_test] "some string"
It does not return the value I need, instead, it returns number of rows in the table with "some string" as values. Any ideas? thanks