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 difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Normalization and denormalization

3 Answers   Wipro,

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

What is a trigger and its types?

0 Answers  

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---