03 How to Pass In Multiple Values

Sometimes you need to pass multiple values into a stored procedure – like a list of locations. The easy answer is to pass in a comma-delimited list, and parse it inside the stored procedure with STRING_SPLIT. However, if you need accurate query estimates, you can run into problems. Video recording to come soon. Demo Script…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.

Sometimes you need to pass multiple values into a stored procedure – like a list of locations. The easy answer is to pass in a comma-delimited list, and parse it inside the stored procedure with STRING_SPLIT. However, if you need accurate query estimates, you can run into problems. Video recording to come soon. Demo Script…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.