Visual Studio does not recognize R packages when executing as a SQL Server stored procedure due to incorrect package locations or manual package installation limitations.

Using Parameterized Queries: A Safer and More Efficient Way to Handle User Input in LIKE SQL Statements