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.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/