asked
Find word count in the database or tables?
How should I find word count in given database or in tables and return table name and count ? Do we have easy way to find this?
How to you define a word? I'm thinking that there could be many strings of characters in a database that aren't actually words and wonder what your rule is for telling them apart from "real" words. If you have multiple "words" in a single column, do you want to use anything besides a single space to delimit them? Do you want to look at certain column for the words, or is every character-based column in the database subject to the count and what about system tables?
use length() function, charindex and patindex() function in sql
13 People are following this question.
