Clever Geek Handbook

SQL Server async procedure execution: how to pass varbinary (MAX)?

I have read and know this wonderful solution from Remus Rusanu for executing asynchronous stored procedures

https://github.com/rusanu/async_tsql

What's a good way to execute a stored procedure with a type parameter varbinary(MAX)

?

How to implement such asynchronous procedure calls?

+3


source to share


1 answer


You cannot use a technique sql_variant

in your article to achieve this, unfortunately. However, nothing prevents you from declaring your Service Broker message as VALIDATION = NONE

:

CREATE MESSAGE TYPE
    [//Adventure-Works.com/Expenses/ReceiptImage]
    VALIDATION = NONE ;


This allows arbitrary binary data to be sent as a message and passed directly to a processing routine. This is of course more limited if you are going to send anything other than one varbinary(max)

, but for asking for it will work.

0


source






More articles:


All Articles