Answer Posted / prasanna

create procedure loopcure
as
BEGIN
declare @a int, @b varchar(020), @l int, @c varchar(020),
@D varchar(020)
SET @D = ''
declare loopcur cursor for select id from names
open loopcur
fetch next from loopcur into @b
while @@fetch_status = 0
begin
select @C = LTRIM(RTRIM(@B)) + ','
select @D = LTRIM(RTRIM(@D)) + LTRIM(RTRIM(@C))
fetch next from loopcur into @b
end
close loopcur
deallocate loopcur
select @d = left(@d, len(@d)-1 )
select @d as final
END

Explain the categories of stored procedure?

921

---

what are acid properties? : Sql server database administration

976

---

Which data type columns are the best candidates for full-text indexing?

956

---

Define clusters?

1036

---

How do you run a trace?

887

---

What are the types of subscriptions in SQL Server replication?

1014

---

Write a code to select distinct records without using the DISTINCT keyword.

1101

---

What is an active database?

999

---

your distribution database is full what will u do

2159

---

Difference between report and query parameter. Why do we need different type of parameter?

932

---

What is nolock hint in sql server 2008

1107

---

What are two difference between sql azure and azure tables?

159

---

Why use “pivot” in sql server?

1092

---

Explain “row_number()” in sql server with an example?

984

---

What is cursors?

1158

---