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

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

What are logical database components? : SQL Server Architecture

0 Answers  

---

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

---

Can XML be used to access data?

2 Answers  

---

Explain what are page splits? : SQL Server Architecture

0 Answers  

---

What is isnull() operator?

0 Answers  

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

What are the extra roles available in msdb? : sql server security

0 Answers  

---

What are the kinds of subquery?

0 Answers  

---