How to get columns in the table

select *
from
INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tblname'

SQL Server, for selecting even and odd rows

select * from Tbl_Users where USER_ID%2=0(for even rows)
select * from Tbl_Users where USER_ID%2=1(for odd rows)

Date Difference in SQL Server

SQL SERVER:
use task
create table date
(Startdate date,
Enddate date)
insert into date values('2013-01-01',GETDATE())

select * from date
select *,DATEDIFF(MONTH,Startdate,Enddate) as diffdate from date