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

What does man by sql wildcard characters in sql server?

1106

---

Does full backup break log chain?

1016

---

What is buffer cash in sql server?

1206

---

What are subquery and its properties?

1105

---

How many types of objects are there?

1073

---

What is postgresql server?

1060

---

How will you add a dimension to cube? : sql server analysis services, ssas

1139

---

What should be the fill factor for indexes created on tables? : sql server database administration

1181

---

how would you store your query in an SSRS report or a Database server?

167

---

What is a domain constraint give an example?

1111

---

Which joins are sql server default?

1072

---

What is data source in connection string?

958

---

Why do we use trigger?

1029

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1072

---

Which is faster statement or preparedstatement?

1003

---