Advertisement
Guest User

SQL Prompt Style Settings

a guest
Oct 13th, 2017
6
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.70 KB | None | 0 0
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <LayoutOptions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Format.Engine.Formatting.Options">
  3. <AlignCaseElseToWhen>true</AlignCaseElseToWhen>
  4. <AlignToTab>true</AlignToTab>
  5. <BetweenAndAlignment>ToBeginningExpression</BetweenAndAlignment>
  6. <BooleanOperatorAlignment>RightAlignedToStatement</BooleanOperatorAlignment>
  7. <BooleanOperatorBreakType>ChopAlways</BooleanOperatorBreakType>
  8. <BreakAssignmentIfLong>false</BreakAssignmentIfLong>
  9. <BreakOnConstraints>true</BreakOnConstraints>
  10. <BuiltInDataTypeCasing>Uppercase</BuiltInDataTypeCasing>
  11. <BuiltInFunctionCasing>Uppercase</BuiltInFunctionCasing>
  12. <CaseEndAlignment>ToCase</CaseEndAlignment>
  13. <CaseExpressionAlignment>ToWhenExpression</CaseExpressionAlignment>
  14. <CaseWhenElseAlignment>ToFirstItem</CaseWhenElseAlignment>
  15. <ClauseAlignment>RightAlignedToStatement</ClauseAlignment>
  16. <ClauseIndentation>0</ClauseIndentation>
  17. <ClosingParenthesisAlignment>ToOpeningBracket</ClosingParenthesisAlignment>
  18. <CollapseCaseExpressionIfShort>false</CollapseCaseExpressionIfShort>
  19. <CollapseCaseIfShortCharacterCount>75</CollapseCaseIfShortCharacterCount>
  20. <CollapseIfShortControlFlowCharacterCount>78</CollapseIfShortControlFlowCharacterCount>
  21. <CollapseIfShortDdlCharacterCount>120</CollapseIfShortDdlCharacterCount>
  22. <CollapseIfShortDmlCharacterCount>75</CollapseIfShortDmlCharacterCount>
  23. <CollapseIfShortParenthesesContentsCharacterCount>78</CollapseIfShortParenthesesContentsCharacterCount>
  24. <CollapseIfShortSubqueryCharacterCount>15</CollapseIfShortSubqueryCharacterCount>
  25. <CollapseShortControlFlowStatements>false</CollapseShortControlFlowStatements>
  26. <CollapseShortDdlStatements>false</CollapseShortDdlStatements>
  27. <CollapseShortDmlStatements>false</CollapseShortDmlStatements>
  28. <CollapseShortParenthesesContents>false</CollapseShortParenthesesContents>
  29. <CollapseShortSubqueries>false</CollapseShortSubqueries>
  30. <CommaAlignment>ToStatement</CommaAlignment>
  31. <ConstraintColumnsBreakType>ChopIfLong</ConstraintColumnsBreakType>
  32. <CreateAlterClosingParenthesisAlignment>ToOpeningBracket</CreateAlterClosingParenthesisAlignment>
  33. <CreateAlterIndentParenthesisedExpression>true</CreateAlterIndentParenthesisedExpression>
  34. <CreateAlterOpeningParenthesisAlignment>RightAlignedToStatement</CreateAlterOpeningParenthesisAlignment>
  35. <CreateAlterOpeningParenthesisBreakType>ChopAlways</CreateAlterOpeningParenthesisBreakType>
  36. <CreateAlterParenthesisLayout>ExpandedRightAligned</CreateAlterParenthesisLayout>
  37. <CreateAlterParenthesisedExpressionBreakType>Never</CreateAlterParenthesisedExpressionBreakType>
  38. <CreateAlterPlaceClosingParenthesisOnNewLine>true</CreateAlterPlaceClosingParenthesisOnNewLine>
  39. <CreateTableBreakBeforeFirstListItem>true</CreateTableBreakBeforeFirstListItem>
  40. <CteAsAlignment>RightAlignedToStatement</CteAsAlignment>
  41. <CteColumnsOpeningParenthesisAlignment>ToStatement</CteColumnsOpeningParenthesisAlignment>
  42. <CteColumnsOpeningParenthesisBreakType>Never</CteColumnsOpeningParenthesisBreakType>
  43. <CteContentsOpeningParenthesisAlignment>ToStatement</CteContentsOpeningParenthesisAlignment>
  44. <CteContentsOpeningParenthesisBreakType>Never</CteContentsOpeningParenthesisBreakType>
  45. <CteContentsParenthesisLayout>CompactSimple</CteContentsParenthesisLayout>
  46. <CteContentsParenthesisedExpressionAlignment>ToStartOfOpeningBracket</CteContentsParenthesisedExpressionAlignment>
  47. <CteContentsParenthesisedExpressionBreakType>Never</CteContentsParenthesisedExpressionBreakType>
  48. <FirstCreateAlterDefintionBreakType>ChopAlways</FirstCreateAlterDefintionBreakType>
  49. <FirstCreateProcedureParamBreakType>ChopAlways</FirstCreateProcedureParamBreakType>
  50. <FirstListItemBreakType>Never</FirstListItemBreakType>
  51. <FromClauseFirstItemBreakType>Never</FromClauseFirstItemBreakType>
  52. <FunctionArgumentsBreakType>SimpleWrap</FunctionArgumentsBreakType>
  53. <GlobalVariablesCasing>LeaveAsIs</GlobalVariablesCasing>
  54. <GroupByOrderByFirstItemBreakType>Never</GroupByOrderByFirstItemBreakType>
  55. <InValuesFirstItemBreakType>SimpleWrap</InValuesFirstItemBreakType>
  56. <InValuesOpeningParenthesisAlignment>RightAlignedToStatement</InValuesOpeningParenthesisAlignment>
  57. <InValuesOpeningParenthesisBreakType>ChopAlways</InValuesOpeningParenthesisBreakType>
  58. <InValuesSubsequentListItemsBreakType>SimpleWrap</InValuesSubsequentListItemsBreakType>
  59. <IndentBeginEndKeywords>true</IndentBeginEndKeywords>
  60. <IndentBlockContents>true</IndentBlockContents>
  61. <IndentCteContents>false</IndentCteContents>
  62. <IndentCteName>false</IndentCteName>
  63. <IndentDdlClauses>true</IndentDdlClauses>
  64. <IndentJoinTable>false</IndentJoinTable>
  65. <IndentListItems>true</IndentListItems>
  66. <IndentParenthesisedExpression>true</IndentParenthesisedExpression>
  67. <InsertEmptyLineBetweenJoins>false</InsertEmptyLineBetweenJoins>
  68. <IsMigratedStyle>false</IsMigratedStyle>
  69. <JoinBreakType>ChopAlways</JoinBreakType>
  70. <JoinClauseAlignment>AsPartOfList</JoinClauseAlignment>
  71. <JoinConditionBreakType>Never</JoinConditionBreakType>
  72. <JoinOnAlignment>TabbedFromJoin</JoinOnAlignment>
  73. <JoinOnConditionAlignment>ToInner</JoinOnConditionAlignment>
  74. <Name>CS Default</Name>
  75. <NewLineAfterTopRowFilter>true</NewLineAfterTopRowFilter>
  76. <NewLineBeforeTopRowFilter>false</NewLineBeforeTopRowFilter>
  77. <NewLineForCorrelatedTableSource>false</NewLineForCorrelatedTableSource>
  78. <NumberOfEmptyLinesAfterBatchSeparator>1</NumberOfEmptyLinesAfterBatchSeparator>
  79. <NumberOfEmptyLinesBetweenStatements>1</NumberOfEmptyLinesBetweenStatements>
  80. <NumberOfSpacesInTab>4</NumberOfSpacesInTab>
  81. <OpeningParenthesisAlignment>RightAlignedToStatement</OpeningParenthesisAlignment>
  82. <OpeningParenthesisBreakType>ChopAlways</OpeningParenthesisBreakType>
  83. <OptionsVersion>11</OptionsVersion>
  84. <OverrideParenthesesOptionsForCreateAlterStatements>true</OverrideParenthesesOptionsForCreateAlterStatements>
  85. <ParenthesisLayout>CompactToStatement</ParenthesisLayout>
  86. <ParenthesisedExpressionAlignment>TabbedFromOpeningBracket</ParenthesisedExpressionAlignment>
  87. <ParenthesisedExpressionBreakType>Never</ParenthesisedExpressionBreakType>
  88. <PlaceBeginOnNewLine>true</PlaceBeginOnNewLine>
  89. <PlaceCaseElseOnNewLine>true</PlaceCaseElseOnNewLine>
  90. <PlaceCaseEndOnNewLine>true</PlaceCaseEndOnNewLine>
  91. <PlaceCaseExpressionOnNewLine>false</PlaceCaseExpressionOnNewLine>
  92. <PlaceCaseFirstWhenOnNewLine>IfTheresAnInputExpression</PlaceCaseFirstWhenOnNewLine>
  93. <PlaceClosingParenthesisOnNewLine>true</PlaceClosingParenthesisOnNewLine>
  94. <PlaceCommasBeforeListItems>false</PlaceCommasBeforeListItems>
  95. <PlaceJoinOnKeywordOnANewLine>true</PlaceJoinOnKeywordOnANewLine>
  96. <PlaceJoinTableOnNewLine>false</PlaceJoinTableOnNewLine>
  97. <PreferBreakBeforeAsKeyword>true</PreferBreakBeforeAsKeyword>
  98. <PreferBreakBeforeBetweenAndKeyword>false</PreferBreakBeforeBetweenAndKeyword>
  99. <PreferBreakBeforeBetweenKeyword>false</PreferBreakBeforeBetweenKeyword>
  100. <PreferBreakBeforeConditionOperator>true</PreferBreakBeforeConditionOperator>
  101. <PreferBreakBeforeCteName>false</PreferBreakBeforeCteName>
  102. <PreferBreakBeforeEquals>false</PreferBreakBeforeEquals>
  103. <PreferBreakBeforeInsertTable>false</PreferBreakBeforeInsertTable>
  104. <PreferBreakBeforeThenKeyword>true</PreferBreakBeforeThenKeyword>
  105. <PreserveLineSpacingBetweenStatements>false</PreserveLineSpacingBetweenStatements>
  106. <PreserveLineSpacingWithinStatements>true</PreserveLineSpacingWithinStatements>
  107. <ReservedKeywordsCasing>Uppercase</ReservedKeywordsCasing>
  108. <SemicolonWhitespace>SpaceBefore</SemicolonWhitespace>
  109. <SpaceBeforeUnits>false</SpaceBeforeUnits>
  110. <SpaceBetweenDataTypeAndParameters>false</SpaceBetweenDataTypeAndParameters>
  111. <SpaceInsideEmptyParentheses>false</SpaceInsideEmptyParentheses>
  112. <SpacesAroundArithmeticOperators>
  113. <m_After>true</m_After>
  114. <m_Before>true</m_Before>
  115. </SpacesAroundArithmeticOperators>
  116. <SpacesAroundCommas>
  117. <m_After>true</m_After>
  118. <m_Before>false</m_Before>
  119. </SpacesAroundCommas>
  120. <SpacesAroundComparisonOperators>
  121. <m_After>true</m_After>
  122. <m_Before>true</m_Before>
  123. </SpacesAroundComparisonOperators>
  124. <SpacesAroundFunctionCallArguments>
  125. <m_After>true</m_After>
  126. <m_Before>true</m_Before>
  127. </SpacesAroundFunctionCallArguments>
  128. <SpacesAroundFunctionCalls>
  129. <m_After>true</m_After>
  130. <m_Before>true</m_Before>
  131. </SpacesAroundFunctionCalls>
  132. <SpacesAroundInPredicateContents>
  133. <m_After>true</m_After>
  134. <m_Before>true</m_Before>
  135. </SpacesAroundInPredicateContents>
  136. <SpacesAroundParentheses>
  137. <m_After>true</m_After>
  138. <m_Before>true</m_Before>
  139. </SpacesAroundParentheses>
  140. <SpacesAroundParenthesesContents>
  141. <m_After>true</m_After>
  142. <m_Before>true</m_Before>
  143. </SpacesAroundParenthesesContents>
  144. <SpacesOrTabs>TabsWherePossible</SpacesOrTabs>
  145. <SubsequentListItemsBreakType>ChopAlways</SubsequentListItemsBreakType>
  146. <UseGlobalListOptionsForDmlStatements>false</UseGlobalListOptionsForDmlStatements>
  147. <UseObjectDefinitionCase>true</UseObjectDefinitionCase>
  148. <VerticallyAlignAliases>false</VerticallyAlignAliases>
  149. <VerticallyAlignClauseItems>true</VerticallyAlignClauseItems>
  150. <VerticallyAlignColumnDefinitions>true</VerticallyAlignColumnDefinitions>
  151. <VerticallyAlignComparisonOperators>true</VerticallyAlignComparisonOperators>
  152. <VerticallyAlignDataTypes>true</VerticallyAlignDataTypes>
  153. <VerticallyAlignJoinConditionWithJoinTable>false</VerticallyAlignJoinConditionWithJoinTable>
  154. <VerticallyAlignListItemComments>true</VerticallyAlignListItemComments>
  155. <VerticallyAlignListItems>true</VerticallyAlignListItems>
  156. <WhereClauseFirstItemBreakType>Never</WhereClauseFirstItemBreakType>
  157. <WrapColumn>100</WrapColumn>
  158. <WrapLongLines>true</WrapLongLines>
  159. </LayoutOptions>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement