SQl query to return month names of a year
jerry brown posted at 14-Mar-08 07:44
Hi ,
I want to load a combo box with the names of all months in a year. I want to do it using MS SQL Server query. I used
SELECT DATENAME(month, getdate() AS 'Month Name'
this only returns the current month. I want the names of all months in a year. pls help
thanks in advance
source :http://www.eggheadcafe.com
-------------------------------------------------------
Trik Gambar Bergerak
Trik Gambar-dimouse
Trik hapus pwd mysql
Trik insertin to db
Trik jadi root dilinux
Trik jam-distatus-bar
Trik Koneksi-ke database
Trik Koneksi-msql-php
Trik lihat-database-mysql
Trik membahas-fungsi-else
Trik member-area
Tidak ada komentar:
Posting Komentar