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 difference between count (*) and count column?
What is faster join or union?
How many tables can be joined in SQL Server?
What are different types of schemas?
How do you rebuild an identity column?
Mention the uses of stored procedures.
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is a fan-out query in SQL Azure?
Can we call stored procedure in view in sql server?
how would you troubleshoot blocking? : Sql server database administration
What is store procedure? How do they work?
What is a recursive stored procedure in sql server?
Explain the relational database management system (rdbms)?