FETCH Layout

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

FETCH Layout

Postby joeleich » Wed Feb 04, 2009 5:19 pm

I prefer to layout my FETCH statements like this (with indented parameters):

FETCH NEXT FROM JOB_PHASE_CURSOR INTO
@i_Phase_Level,
@Company,
@JobNumber,
@PhaseCode,
@PhaseControlCode,
@UnitOfMeasure,
@PhaseName,
@OriginalDollarEstimate,
@OriginalQuantityEstimate,
@RevisedDollarEstimate,
@RevisedQuantityEstimate,
@Active

I noticed a similar request in a related post where the poster was suggesting that the EXECUTE statement layout similarly. The feature request was SR-823. Is it possible to add this layout option to that?
joeleich
 
Posts: 1
Joined: Wed Feb 04, 2009 4:50 pm

Postby David Atkinson » Wed Feb 04, 2009 6:01 pm

Done!

Thanks for the suggestion.

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests