Using SQL Server 2008 R2. I am trying to run a stored procedure manually using the below format
proc_name paramValue1, paramValue2
One my parameters has commas in it and I can't figure out the syntax to pass that parameter's value. What do I need to do it? Example
usp_My Proc, @paramValue1 = 'Me', @paramValue2 = 'City', 'State', 'Zip'