Answer Posted / pradyumna

declare @temp table
(name char(1),counter int)
declare @str varchar(10)
set @str='bhaskar'

declare @strlen int
set @strlen=len(@str)
declare @ctr int
set @ctr=1

declare @Alpha char(1)

while @ctr<=@strlen
begin
set @alpha=substring(@str,@ctr,@strlen-(@strlen-
@ctr))
if not exists (select 1 from @temp where name=@alpha)
begin
insert into @temp values(@alpha,1)
end
else
begin
update @temp set counter=counter+1 where name=@alpha
end
set @ctr=@ctr+1
end

select * from @temp

How to delete an existing database user?

968

---

What is the function of inner join?

1004

---

How do I find the port number for sql server?

922

---

Can a database be shrunk with users active?

1063

---

What are the types of ssrs?

139

---

Where are SQL server users names and passwords are stored in sql server?

1197

---

What number sorts of privileges are accessible in sql?

979

---

How do I clean up sql server transaction log?

993

---

How can we delete Duplicate row in table?

999

---

How to execute stored procedure and set temp table in sql server?

993

---

What is onf in normalization form?

999

---

What are the types of database recovery models?

1055

---

What is the web service used for reporting services?

114

---

What is the difference between rank and dense_rank?

990

---

How do I find sql server instance name?

915

---