Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Is it possible to update the hosted assembly with a new one? Guessing not. Would like new features found in SqlGeography, like STContains() and not have to write ugly SQL workaround.

//Daniel

share|improve this question

1 Answer

up vote 1 down vote

I suspect such a change would require a whole lot more than just swapping out a DLL to get the new definition. How would the engine know how to parse never mind process the function? You can't just add FORMAT() or DATETIMEFROMPARTS() to earlier versions by checking in a DLL either.

I think the only way you'll be able to get SqlGeography.STContains() is to upgrade to a version that has it (SQL Server 2012).

share|improve this answer
Or write my own – Daniel Nov 15 '12 at 15:23
Sure, you could write your own. But do you really want to? To what end? So you can replace all those references with the native function when you upgrade? – Aaron Bertrand Nov 15 '12 at 15:27
Of course I will not write my own. And upgrading to SQL2012 is not an option. Will go with the ugly SQL dance. – Daniel Nov 15 '12 at 21:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.