SQL Server CLR Help

I appreciate that once an assembly is registered that you can so something like

EXEC ClrSpEmployeeByShift @shiftID=1

Where shiftID is an expected parameter but what if I want to use a class as an object ie set numerous properties then call a function or sub
Who is Participating?
CodeCruiserConnect With a Mentor Commented:
You can then probably exchange a datatable.

Following example is from .NET to SQL but other way round should be similar

I think to be able to exchange objects as parameters, you need to declare that as a user defined data type in SQL Server and then you can use it.

rocky050371Author Commented:
Essentially it could be n number of name value pairs, then once they have all been passed I want to call a function based on the collection of values
rocky050371Author Commented:
In OLE you can simply create an use an object, I wonder if a paramarray is possible?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.