Answer Posted / deepak

declare @Str As varchar(100)
declare @StrNew As varchar(100)
-- You can set any string (max 100 len)
set @Str = 'Bhaskar'
set @StrNew = @Str
declare @PrintVal varchar(10)


While @StrNew <> ''
BEGIN
set @StrNew = Replace(@Str, left(@Str, 1), '')
set @PrintVal= (left(@Str,1) + cast((len(@Str)-Len
(@StrNew)) as varchar(5)))
print @PrintVal + ' ' + @StrNew +' ' +@Str
set @Str = @StrNew
END

why would you call update statistics? : Sql server database administration

1063

---

What are advantages of ssrs or why we should use ssrs?

137

---

difference between Clustered index and non clustered index ?

977

---

What is for xml in sql server?

1042

---

Is it possible to have clustered index on separate drive from original table location?

946

---

What is the osql utility?

941

---

What is a functions and types in sql server?

1063

---

Is it true, that there is no difference between a rule and a check constraint?

1021

---

Explain subquery and state its properties?

1020

---

How to create median function?

164

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1025

---

What language is sql server written in?

1012

---

Explain the difference between primary keys and foreign keys?

1004

---

What different steps will a sql server developer take to secure sql server?

966

---

Mention the 3 ways to get a count of the number of records in a table.

961

---