• techmarimuthu (6/25/2013)


    create table members

    (

    id int identity,

    firstname varchar(30),

    lastname varchar(40),

    dob int

    )

    insert into members(firstname,lastname,dob) values ('Michel','David',19890630)

    insert into members(firstname,lastname,dob) values ('Raja','Kumar',19900625)

    insert into members(firstname,lastname,dob) values ('Rahul','Sundar',19910501)

    insert into members(firstname,lastname,dob) values ('Arun','Edward',19901219)

    i wanna result like dob in 25 june to 31 june of this year....

    Why is the data type of the column dob INT? Any particular reason.


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/