But what if you do not want to create this big table in the database? You can use UNION operator.
SELECT 1, 'January' UNION ALL
SELECT 2, 'February' UNION ALL
...
SELECT 12, 'December'
Or make them a stored procedure.
http://stackoverflow.com/questions/1376361/returning-data-without-accesing-a-table
No comments:
Post a Comment