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

Can we drop user if user mapped to any logins

1 Answers  

---

How to enter comments in transact-sql statements?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

CREATE a table from another table

2 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

What is difference between join and natural join?

0 Answers  

---

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

0 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

What is an index. What are the types?

0 Answers  

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---