How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
Answer Posted / amit kumar
firstaly take string in any variable. then index with start(')
and end(');then u got the full string length. after that u
substring one character and add (:1) and so on to reach the
last character..
and finally u get result.
bye
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is transaction server explicit transaction?
Can a function call a stored procedure in sql server?
Can we create clustered index on composite key?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is rolap and its advantage? : sql server analysis services, ssas
How can we delete Duplicate row in table?
Do you know what is rank function?
How to see existing views in ms sql server?
What is the difference between grant and with grant while giving permissions to the user?
How do I find the port number for sql server?
What is the command to change the recovery model?
Explain the steps to use transact-sql cursor?
What does it mean if @@cursor_row returns a negative number?
What happens if null values are involved in boolean operations?