Answer Posted / kumar.t

1. First To create the following table.

Create table NewNew(sno int identity(1,1) primary key,
names varchar(100))

2. To INsert the record one by one

Insert Into NewNew Values ('A')
Insert Into NewNew Values ('B')
Insert Into NewNew Values ('C')
Insert Into NewNew Values ('D')
Insert Into NewNew Values ('F')

3. To view the records first

Select * From NEwNew

4. To create the following procedure

Create Proc New1
As
Begin
Declare @names varchar(100)
Declare @sQuery Varchar(7000)
Declare @sQuery1 Varchar(1000)
Declare @ans varchar(8000)
Declare @i int
Declare cur cursor for select names from newnew
Open cur
Set @i = 1
Set @sQuery1 = ''
Set @sQuery = ''
fetch next from cur into @names
While @@fetch_status=0
Begin
Set @sQuery1 = '(Select Top 1 names
from newnew where names in (select top '+ convert(varchar
(3),@i) +' names From newnew order by 1 Asc) order by 1
Desc) As names,'
Set @sQuery = @squery + @squery1
Set @i = @i + 1
Fetch next from cur into @names
End
Set @ans = Convert(varchar(6),'Select ') +
Left(@sQuery,Len(@sQuery)-1)
Exec (@ans)
Close cur
deallocate cur
End

5. To execute the procedure
now to view the output Ok

Exec New1


By
Kumar.T

How to change a login name in ms sql server?

1071

---

Why truncate is ddl?

1078

---

What are the types of stored procedures in an sql server?

981

---

what is a join and explain different types of joins? : Sql server database administration

953

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1031

---

Explain system rowset functions?

988

---

What is query optimizer in sql server?

1013

---

What is sharding?

116

---

What is a ddl statement?

905

---

What is primary key and example?

936

---

What does null mean?

980

---

What is the difference between dbcc indexdefrag and dbcc reindex?

981

---

Define inner join in sql server joins?

1047

---

What’s the distinction between dropping a info and taking a info offline?

1032

---

What is the beast way to write CTE in SQL Server ?

1039

---