Answer / gopi muluka

Using DATEADD Function compare get the requited values

SELECT DATEADD(DD,-6,GETDATE())

Answer / jitendra sharma

SELECT DATEADD(DD,-6,GETDATE()) this is right...........

Answer / 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

Answer / sreeram

select convert(varchar,cast(dateadd(dd,-6,getdate()) as datetime),101)

ans:09/21/2010

ofcourse the above are also correct

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What are the type of Indexes? which one is best, why?

6 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

What are different types of subquery?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

What is Replication?

0 Answers  

---