Database

SELECT * 
FROM  test 
WHERE date BETWEEN CONVERT(datetime, '8/08/1429', 131) AND CONVERT(datetime, '12/08/1429', 131)

rameez Raja wrote:

iam using sql server 2000 and now wants to move sql server 2005 where i have to start?

BNo
---
73
36 
457

BNo Stops
--- -----
73  abc 
73  xyz 
73  wer 
36  qwe 
36  abc 
36  wer
457 abc 
457 ghi 
457 klm

SELECT *
FROM bus
WHERE EXISTS (SELECT 1
              FROM   busstops bs1
              WHERE  bs1.BNo   = bus.BNo
              AND    bs1.Stops = 'abc')
AND   EXISTS (SELECT 1
              FROM   busstops bs2
              WHERE  bs2.BNo   = bus.BNo
              AND    bs2.Stops = 'wer')

SELECT *
FROM bus
WHERE BusNo = @BusNo

DECLARE @Id int

UPDATE emp SET id=(SELECT MAX(id) FROM emp);
SELECT @id=MAX(id) FROM emp;
RETURN @id;