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 are the differences between char and varchar in ms sql server?
Explain steps of normalization?
What is the advantage of sql server?
What happens if we shrink log file in sql server?
What is the difference between composite index and covering index?
List out a number of the wants to setup a SQL Server failover cluster?
What happens if you delete a table that is used by a view?
How to perform backup for certificates in sql server? : sql server security
What are pages and extents? : SQL Server Architecture
How to see existing views in ms sql server?
Why and when do stored procedure recompile?
How do I completely remove sql server instance?
Why olap is used?
What is the difference between char, varchar and nvarchar?
Can you please differentiate between a primary key and a unique key?