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
List out the differences between global and local temp tables in sql server?
Explain acid?
How many instances per computer are there in sql server 2000?
What is the difference between functions and stored procedures?
What is join and name different type of joins?
Define Business Edition in SQL Azure?
What is the difference between DATETIME2 and DATETIME?
What is the difference between char and varchar2 datatype in sql?
How do I save a stored procedure in sql server?
What are the new features of sql server 2008 r2 reporting service?
What are the dis_advantages of stored procedures, triggers, indexes?
What command would you use to add a column to a table in sql server?
How to create a testing table with test data in ms sql server?
What is the use of group by clause?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration