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

Define the one-to-one relationship while designing tables.

908

---

what is bit datatype? : Sql server database administration

924

---

How can you ensure that the database and sql server based application perform well?

1085

---

Do you know how to make remote connection in database?

968

---

Explain about protocol layer present in SQL server?

1211

---

List the different index configurations possible for a table?

937

---

How to drop an existing table with "drop table" statements in ms sql server?

1090

---

How do I create an extended event in sql server?

958

---

Do you know what is difference between stored procedure and user defined function?

1099

---

What objects does the fn_my_permissions function reports on? : sql server security

1043

---

What are two difference between sql azure and azure tables?

159

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

994

---

What is cursor in ms sql server?

1155

---

What is de-normalization and what are some of the examples of it?

976

---

Write a sql query to get zero records from a table having n number of records?

1181

---