Tip of the Day:January 2

From sasCommunity
Jump to: navigation, search

sasCommunity Tip of the Day

The SQL INSERT statement does not permit use of an ORDERED BY clause to control the order in which the new rows are stored. To work around this limitation, define a named view and include the ORDERED BY clause in its definition, then invoke the view in the INSERT statement.

Submitted by Howles. Contact me at my Discussion Page.



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip