Post reply

Count the Number of "words" in a database...

  • July 16, 2004 at 3:01 pm

    #109095

    I've never ever been approached and asked to give a total count of "all the words" in a database.

    This seems incredulous, but the purpose is for "translating" text. I don't know how to even approach this for Sql Server...

    Comments, suggestions, and witty remarks are all welcomed

    -- Francisco

  • July 16, 2004 at 4:07 pm

    #514966

    bcp out some sample rows/tables, load into Word, Tools |+ Word Count

     

    The multiple out for an estimate. Believe me, no one is going to check your math

  • July 16, 2004 at 4:48 pm

    #514971

    simply ingenious [Big Grin]

    -- Francisco

  • July 17, 2004 at 6:53 am

    #514977

    use pubs

    select pub_name,1+len(pub_name)-len(replace(pub_name,' ','')) as wordcount from publishers

    compute sum(1+len(pub_name)-len(replace(pub_name,' ','')))

    --/rockmoose


    You must unlearn what You have learnt

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply