November 20, 2014 at 1:05 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 20, 2014 at 2:50 am
Igor Micev (11/19/2014)
serg-52 (11/19/2014)
Thanks, good question.I was not sure but rather had an impression that sending parameter of the UDT declared in the current DB to the proc in the other DB must fail. UDT are DB-scoped types, aren't they?
P.S.
Wonder if BOL has any other topic besides CLR UDTs that states " UDTs are scoped to a single database, and cannot be used in multiple databases ..."
http://msdn.microsoft.com/en-US/library/ms131079(v=sql.100).aspx
That was the reason for putting this question here. UDT as TABLE cannot be used in different DB-scope, and UDT as INT type (given in explanation), for example, can be used.
Thanx 4 the question & the info.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
November 20, 2014 at 5:33 am
Yeah, that we a good one and a very good explanation. Thanks.
November 20, 2014 at 5:50 am
Interesting question and great helpful suggestions!
November 20, 2014 at 6:39 am
Thanks for the question.
November 20, 2014 at 8:12 am
Good question, Igor, and very interesting. Thanks!
November 20, 2014 at 11:44 am
A nice fun question, required a bit of careful thought to get it right but not really difficult if one remembers that the scope of a UDT is the database.
Tom
Viewing 7 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply