In SQL Server 2005 New query window for any database. declare @CharVal v

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

Question Posted / suni soni

9 Answers
11547 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / suni soni

In SQL Server 2005 New query window for any database.

declare @CharVal varchar(100),@i int
declare @temp table (CharVal varchar(10))

set @a='Bhaskar'

set @i=1
while (@i<=len(@a))
begin

insert into @temp values (substring(@a,@i,1))

set @i=@i +1

end

select CharVal, count(*) from @temp group by CharVal

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is snapshot replication?

1037

which backup strategy you are following at ur company

2133

What is store procedure? When do you use?

910

Can we shrink data file in sql server?

1027

What does asynchronous call backs means?

1129

How do I run sql server 2014?

968

Does index slows down insert statements?

984

What is difference between Datepart() and Datename() in SqlServer?

1188

Explain how many types of relationship?

1009

What is resource db in sql server?

1000

Define self join?

1017

How to change the name of a database user?

945

Explain temporary table vs table variable by using cursor alternative?

975

What is the new security features added in sql server 2016? : sql server security

1090

Explain what are commit and rollback in sql?

911