CLR Stored Procedures....What data types can you input?

[NewsBot]

Hey C9!

 

I've decided to try out CLR stored procedures for my new web app. One thing I can't seem to figure out (google's not helping too much as I get the same articles over and over again) is, is it possible to input any object into the procedure?

 

Like, if I have an Employee object, can I just pass that into the stored procedure, and then call Employee methods to construct the SQL string within the procedure? Or can I only input T-SQL types?

 

When I go to deploy it in SQL Server, it doesn't complain about the custom data types. Until I go to test it with actual code, I wont know.

 

So, do you guys off the top of your head know what*a clr stored procedure can contain and what it can't?

 

Thanks!

 

More...

 

View All Our Microsft Related Feeds