- Admin
- #1
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
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