T-SQL Serialization
Is it possible for T-SQL to do some deserialization.
I have this function that accepts a UDT parameter. Now what I want is to pass this directly to my stored procedure. Normally, what I will do is to pass each of my UDTs element and if my UDTs has 20 elements then I would have 20 parameters in my SP. What I want is to pass this a a whole string and deserialize it in T-SQl.
In connection, is passing too much parameters to a stored proc will cause much network traffic than passing a huge string? I need the concept here as this will answer the above.
Thanks.
|