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

What is Lock table in SQL?

0 Answers   Wipro,

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

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  

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

What is built-in function?

0 Answers  

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

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

0 Answers  

---