Home Forums SQL Server 2008 SQL Server 2008 - General Can use clr function in select but not in update RE: Can use clr function in select but not in update

  • June 28, 2013 at 6:25 am

    #1628271

    Japie i personally use CLR functions all the time, so it's probably how you are using it in an update, rather than the CLR being a problem all by itself.

    can you show us your sample UPDATE statement you might use?

    if the CLR is being used against a lot of rows, you might want to change it from a scalar function to a table value function instead; it returns results faster, but the usage is more akin to joining it to a table.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!