Viewing 2 posts - 1 through 2 (of 2 total)
A simpler way to avoid "Select * " is to use "for xml path" to get columns:
SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + ' AS SELECT...
June 17, 2013 at 7:42 pm
#1624845
FYI: Pacific flights crossing the date line can arrive the day before - eg:Air NewZealand NZ4082 Auckland to Tahiti(Papeete) Departs 3:50pm Sunday 16th Dec & arrives 9:50pm Saturday 15th Dec.
December 12, 2012 at 10:59 pm
#1568156