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

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1060

---

Can I save my report as html, excel or word? : sql server management studio

1008

---

What is difference between rownum and rowid?

955

---

What is tabulation?

1012

---

What is an indice?

1082

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2111

---

What are the advantages of sql stored procedure?

1121

---

What is database dimension? : sql server analysis services, ssas

1138

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2075

---

Can sql servers link to other servers?

1135

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1087

---

Explain the difference between cross join and full outer join?

1030

---

What do you understand by coalesce in sql server?

1127

---

How to automatically create a log when an exception is being received into SQL Server?

1357

---

List types of tables in SQL Azure?

128

---