Answer Posted / sanjay kumar dindaa

Declare @strInput as varchar(20)
declare @intLocal as int
declare @chrLocal as char
DECLARE @strLocal varchar(10)
DECLARE @strFinal varchar(100)

Set @intLocal=1
Set @chrLocal=1
Set @strInput='bhaskar'


If exists (Select 1 from sys.tables where name ='temp')
DROP TABLE temp
Create table temp(chrValue Char(1), Cnt Int)

while (@intLocal < len(@strInput) )
begin
set @chrLocal = Substring(@strInput,@intLocal,1)
IF (Select Count(1) from temp Where chrvalue=@chrLocal)> 0
UPDATE TEMP
Set Cnt=Cnt+1
Where chrValue=@chrLocal
else
Insert Into temp (chrValue, Cnt ) values ( @chrLocal,1)
set @intLocal = @intLocal+1
end


Set @strFinal=''
DECLARE @curLocal CURSOR
SET @curLocal = CURSOR FOR
Select ChrValue + ': '+ Cast(cnt as varchar(2)) from temp

OPEN @curLocal
FETCH NEXT
FROM @curLocal INTO @strLocal
WHILE @@FETCH_STATUS = 0
BEGIN
----PRINT @strLocal
Set @strFinal =@strFinal + ' ' + @strLocal
FETCH NEXT
FROM @curLocal INTO @strLocal
END
CLOSE @curLocal
DEALLOCATE @curLocal
PRINT @strFinal

Output :



(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
b: 1 h: 1 a: 2 s: 1 k: 1

What do you understand by physical_only option in dbcc checkdb?

1026

---

What is 3nf normalization?

1051

---

List down some advantages of sql stored procedure?

1016

---

State a few properties of relational databases?

1182

---

What are the triggers in sql?

1170

---

optimization techinques

2721

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

1056

---

What does dml stand for?

998

---

What is equi join with example?

1230

---

How to add the custom code in Report?

129

---

How to find the second highest salary of an employee?

1224

---

Is the primary key column of a table an index in ms sql server?

1005

---

What is an index. What are the types?

1165

---

What are the disadvantages of using querystrings to send data from one page to another?

1073

---

Differentiate between mongodb vs. Sql server?

1142

---