Symptoms

Is it possible to upload attachments into a sql table using a K2 smartobject based on a sql stored procedure?
 

Diagnoses

1. K2 will store an attachment (from an attachment control/file property) as an XML structure with the file’s name and Base64 encoded file in the database.

2. As such the following datatype flow will apply:
Database (nvarchar(max) column) <-> Smartobject (File property) <-> Attachment Control

Using a stored procedure to insert this data in the nvarchar(max) column is possible, if the Smartobject Property is of a File type and the Attachment Control is used when passing the attachment to your custom Smartobject Method based of the SQL stored procedure.
 

Resolution

This can be implented.