SQL Server Performance

Get the count of the given word

Discussion in 'Third Party Tools' started by dineshasanka, May 25, 2005.

  1. dineshasanka Moderator

    Hi gurus,
    Have you found any tool from which i can point to a sp and get the count of the given word. Currently I am using .net to accomplish this. But this is time consuming.

  2. Madhivanan Moderator

    Dinesh,Are you trying to count the word from database field or a file?
    How are you doing this in .NET?
    As there is no split function in SQL Server, in .NET split the word by delimiter and insert all the words in temporary table and

    Select count(word) from WordTable where word='SearchedWord'

    For third party control, see this
    http://www.surefiresoftware.com/totalassistant/featurestable.php



    Madhivanan

    Failing to plan is Planning to fail
  3. dineshasanka Moderator

    Sorry madivan my idea is to check in sps. that is get a count of a certain word in a sp


    quote:Originally posted by Madhivanan

    Dinesh,Are you trying to count the word from database field or a file?
    How are you doing this in .NET?
    As there is no split function in SQL Server, in .NET split the word by delimiter and insert all the words in temporary table and

    Select count(word) from WordTable where word='SearchedWord'

    For third party control, see this
    http://www.surefiresoftware.com/totalassistant/featurestable.php



    Madhivanan

    Failing to plan is Planning to fail

Share This Page