stored procedure format with like
I would like to know if there is a way to format the sql with a parameter
passed to it to get the result.
dim fName as string = Tom
exec SP_GetPersonInfo + fName
@FName VarChar(255)
SELECT Gender, Height, Weight, Age
FROM Person
WHERE FirstName LIKE ('fName %') <-- how would I format this?
No comments:
Post a Comment