Answer Posted / gopi muluka

DECLARE @STR VARCHAR(50),
@Char VARCHAR(10),@N INT, @CNT INT
DECLARE @TAB TABLE (VAL VARCHAR(30), CNT INT)

SET @STR='A,B,C,D,E,F,C,A,S,K,C,B'
SET @CHAR=''
SET @N=1
SET @CNT=1
WHILE @N>0
BEGIN
PRINT @STR
SET @CHAR=SUBSTRING(@STR,1,CHARINDEX(',',@STR)-1)
IF NOT EXISTS(SELECT 1 FROM @TAB WHERE VAL=@CHAR)
INSERT @TAB VALUES (@CHAR,@CNT)
SET @STR=SUBSTRING(@STR,CHARINDEX(',',@STR)+1,115)
IF CHARINDEX(@CHAR,@STR)>0
BEGIN
UPDATE @TAB
SET CNT=CNT+1
WHERE VAL=@CHAR
END
SET @N=CHARINDEX(',',@STR)
PRINT @N
END
SELECT * FROM @TAB

What is a clob in sql?

1027

---

What do you mean by stored procedures? How do we use it?

1001

---

what is the difference between delete and truncate statement in sql? : Sql dba

1256

---

what is the difference between join and union? : Sql dba

1123

---

Why we use stored procedure instead of query?

1007

---

explain the difference between delete , truncate and drop commands? : Sql dba

1101

---

What is difference between stored procedures and application procedures?

1023

---

What are pl/sql cursors?

1060

---

What is the use of & in pl sql?

1051

---

What is the order of sql select?

1045

---

List and explain the different types of join clauses supported in ansi-standard sql?

1359

---

what is the difference between truncate and delete statement? : Transact sql

1075

---

what are the types of join and explain each? : Sql dba

1047

---

How do you rank data in sql?

1011

---

Which is faster subquery or join?

1229

---