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

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

Explain what is row_number function?

0 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

What are orphan records?

0 Answers  

---

How to trouble shoot if unable to connect SQL Server

0 Answers  

---

What is the default fill factor value?

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

What is implicit cursors?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What types of replication are supported in sql server?

0 Answers  

---