Answer Posted / hairlin vasanth raj

ALTER procedure [dbo].[p1]
as
declare
@i int
set @i = 0
begin
set nocount on
while (@i < 6)
begin
SELECT DATEADD(DD,-@i,GETDATE()) as date
set @i=@i+1
end
end


exec p1

Can you explain full-text query in sql server?

970

---

What are translations and its use? : sql server analysis services, ssas

993

---

What is coalesce and check constraint in sql server?

1042

---

What happens if the update subquery returns no rows in ms sql server?

1073

---

What is the use of partition by in sql server?

883

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1116

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

911

---

Explain “@@rowcount” and “@@error” in sql server?

1004

---

Explain what you mean by 3 tier architecture.

1018

---

What are the fixed server level roles? : sql server security

1052

---

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

1032

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

998

---

What are a scheduled jobs?

908

---

How to return the date part only from a sql server datetime datatype?

1022

---

Define Joins?

975

---