How can we help you today? How can we help you today?
sdks
Activity overview Badges (0) Posts (16) Comments (28)

Comments

Sort by recent activity
I have no idea why code formatting is not working in my post. It looks good while I am editing / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt throws error when trying to use intellisense
I have no idea why code formatting is not working in my post. It looks good while I am editing
0 votes
These are the style settings I use: <?xml version="1.0" encoding="utf-8"?> <LayoutOptions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Format.Engine.Formatting.Options"> <AlignCaseElseToWhen>true</AlignCaseElseToWhen> <AlignToTab>false</AlignToTab> <BetweenAndAlignment>ToBetween</BetweenAndAlignment> <BooleanOperatorAlignment>RightAlignedToStatement</BooleanOperatorAlignment> <BooleanOperatorBreakType>ChopIfLong</BooleanOperatorBreakType> <BreakAssignmentIfLong>false</BreakAssignmentIfLong> <BreakOnConstraints>true</BreakOnConstraints> <BuiltInDataTypeCasing>Uppercase</BuiltInDataTypeCasing> <BuiltInFunctionCasing>Uppercase</BuiltInFunctionCasing> <CaseEndAlignment>ToCase</CaseEndAlignment> <CaseExpressionAlignment>Tabbed</CaseExpressionAlignment> <CaseWhenElseAlignment>ToFirstItem</CaseWhenElseAlignment> <ClauseAlignment>RightAlignedToStatement</ClauseAlignment> <ClauseIndentation>0</ClauseIndentation> <ClosingParenthesisAlignment>ToOpeningBracket</ClosingParenthesisAlignment> <CollapseCaseExpressionIfShort>true</CollapseCaseExpressionIfShort> <CollapseCaseIfShortCharacterCount>75</CollapseCaseIfShortCharacterCount> <CollapseIfShortControlFlowCharacterCount>78</CollapseIfShortControlFlowCharacterCount> <CollapseIfShortDdlCharacterCount>75</CollapseIfShortDdlCharacterCount> <CollapseIfShortDmlCharacterCount>75</CollapseIfShortDmlCharacterCount> <CollapseIfShortSubqueryCharacterCount>55</CollapseIfShortSubqueryCharacterCount> <CollapseShortControlFlowStatements>true</CollapseShortControlFlowStatements> <CollapseShortDdlStatements>true</CollapseShortDdlStatements> <CollapseShortDmlStatements>true</CollapseShortDmlStatements> <CollapseShortSubqueries>true</CollapseShortSubqueries> <CommaAlignment>ToList</CommaAlignment> <ConstraintColumnsBreakType>ChopIfLong</ConstraintColumnsBreakType> <CreateAlterClosingParenthesisAlignment>ToClause</CreateAlterClosingParenthesisAlignment> <CreateAlterIndentParenthesisedExpression>true</CreateAlterIndentParenthesisedExpression> <CreateAlterOpeningParenthesisAlignment>ToStatement</CreateAlterOpeningParenthesisAlignment> <CreateAlterOpeningParenthesisBreakType>ChopAlways</CreateAlterOpeningParenthesisBreakType> <CreateAlterParenthesisedExpressionBreakType>Never</CreateAlterParenthesisedExpressionBreakType> <CreateAlterPlaceClosingParenthesisOnNewLine>true</CreateAlterPlaceClosingParenthesisOnNewLine> <CreateTableBreakBeforeFirstListItem>true</CreateTableBreakBeforeFirstListItem> <CteAsAlignment>RightAlignedToStatement</CteAsAlignment> <CteColumnsOpeningParenthesisAlignment>Tabbed</CteColumnsOpeningParenthesisAlignment> <CteColumnsOpeningParenthesisBreakType>ChopAlways</CteColumnsOpeningParenthesisBreakType> <CteContentsOpeningParenthesisAlignment>ToStatement</CteContentsOpeningParenthesisAlignment> <CteContentsOpeningParenthesisBreakType>Never</CteContentsOpeningParenthesisBreakType> <CteContentsParenthesisedExpressionAlignment>ToStartOfOpeningBracket</CteContentsParenthesisedExpressionAlignment> <CteContentsParenthesisedExpressionBreakType>ChopIfLong</CteContentsParenthesisedExpressionBreakType> <FirstCreateAlterDefintionBreakType>ChopIfLongOrMultipleItems</FirstCreateAlterDefintionBreakType> <FirstListItemBreakType>Never</FirstListItemBreakType> <FromClauseFirstItemBreakType>Never</FromClauseFirstItemBreakType> <FunctionArgumentsBreakType>ChopIfLong</FunctionArgumentsBreakType> <GlobalVariablesCasing>LeaveAsIs</GlobalVariablesCasing> <GroupByOrderByFirstItemBreakType>Never</GroupByOrderByFirstItemBreakType> <InValuesFirstItemBreakType>SimpleWrap</InValuesFirstItemBreakType> <InValuesOpeningParenthesisAlignment>ToStatement</InValuesOpeningParenthesisAlignment> <InValuesOpeningParenthesisBreakType>Never</InValuesOpeningParenthesisBreakType> <InValuesSubsequentListItemsBreakType>SimpleWrap</InValuesSubsequentListItemsBreakType> <IndentBeginEndKeywords>true</IndentBeginEndKeywords> <IndentBlockContents>true</IndentBlockContents> <IndentCteContents>false</IndentCteContents> <IndentCteName>false</IndentCteName> <IndentDdlClauses>true</IndentDdlClauses> <IndentJoinTable>false</IndentJoinTable> <IndentListItems>true</IndentListItems> <IndentParenthesisedExpression>true</IndentParenthesisedExpression> <InsertEmptyLineBetweenJoins>false</InsertEmptyLineBetweenJoins> <IsMigratedStyle>false</IsMigratedStyle> <JoinBreakType>ChopAlways</JoinBreakType> <JoinClauseAlignment>RightAlignedToStatement</JoinClauseAlignment> <JoinConditionBreakType>Never</JoinConditionBreakType> <JoinOnAlignment>ToJoin</JoinOnAlignment> <JoinOnConditionAlignment>ToOnKeyword</JoinOnConditionAlignment> <Name>Timepayment</Name> <NewLineAfterTopRowFilter>false</NewLineAfterTopRowFilter> <NewLineBeforeTopRowFilter>false</NewLineBeforeTopRowFilter> <NewLineForCorrelatedTableSource>true</NewLineForCorrelatedTableSource> <NumberOfEmptyLinesAfterBatchSeparator>1</NumberOfEmptyLinesAfterBatchSeparator> <NumberOfEmptyLinesBetweenStatements>1</NumberOfEmptyLinesBetweenStatements> <NumberOfSpacesInTab>4</NumberOfSpacesInTab> <OpeningParenthesisAlignment>RightAlignedToStatement</OpeningParenthesisAlignment> <OpeningParenthesisBreakType>Never</OpeningParenthesisBreakType> <OptionsVersion>10</OptionsVersion> <OverrideParenthesesOptionsForCreateAlterStatements>true</OverrideParenthesesOptionsForCreateAlterStatements> <ParenthesisedExpressionAlignment>TabbedFromOpeningBracket</ParenthesisedExpressionAlignment> <ParenthesisedExpressionBreakType>ChopIfLong</ParenthesisedExpressionBreakType> <PlaceBeginOnNewLine>true</PlaceBeginOnNewLine> <PlaceCaseElseOnNewLine>true</PlaceCaseElseOnNewLine> <PlaceCaseEndOnNewLine>true</PlaceCaseEndOnNewLine> <PlaceCaseExpressionOnNewLine>false</PlaceCaseExpressionOnNewLine> <PlaceCaseFirstWhenOnNewLine>IfTheresAnInputExpression</PlaceCaseFirstWhenOnNewLine> <PlaceClosingParenthesisOnNewLine>true</PlaceClosingParenthesisOnNewLine> <PlaceCommasBeforeListItems>true</PlaceCommasBeforeListItems> <PlaceJoinOnKeywordOnANewLine>false</PlaceJoinOnKeywordOnANewLine> <PlaceJoinTableOnNewLine>false</PlaceJoinTableOnNewLine> <PreferBreakBeforeAsKeyword>false</PreferBreakBeforeAsKeyword> <PreferBreakBeforeBetweenAndKeyword>false</PreferBreakBeforeBetweenAndKeyword> <PreferBreakBeforeBetweenKeyword>false</PreferBreakBeforeBetweenKeyword> <PreferBreakBeforeConditionOperator>true</PreferBreakBeforeConditionOperator> <PreferBreakBeforeCteName>false</PreferBreakBeforeCteName> <PreferBreakBeforeEquals>false</PreferBreakBeforeEquals> <PreferBreakBeforeInsertTable>false</PreferBreakBeforeInsertTable> <PreferBreakBeforeThenKeyword>false</PreferBreakBeforeThenKeyword> <PreserveLineSpacingBetweenStatements>false</PreserveLineSpacingBetweenStatements> <PreserveLineSpacingWithinStatements>false</PreserveLineSpacingWithinStatements> <ReservedKeywordsCasing>Uppercase</ReservedKeywordsCasing> <SemicolonWhitespace>None</SemicolonWhitespace> <SpaceBeforeUnits>false</SpaceBeforeUnits> <SpaceBetweenDataTypeAndParameters>false</SpaceBetweenDataTypeAndParameters> <SpaceInsideEmptyParentheses>false</SpaceInsideEmptyParentheses> <SpacesAroundArithmeticOperators> <m_After>true</m_After> <m_Before>true</m_Before> </SpacesAroundArithmeticOperators> <SpacesAroundCommas> <m_After>true</m_After> <m_Before>false</m_Before> </SpacesAroundCommas> <SpacesAroundComparisonOperators> <m_After>true</m_After> <m_Before>true</m_Before> </SpacesAroundComparisonOperators> <SpacesAroundFunctionCallArguments> <m_After>false</m_After> <m_Before>false</m_Before> </SpacesAroundFunctionCallArguments> <SpacesAroundFunctionCalls> <m_After>false</m_After> <m_Before>false</m_Before> </SpacesAroundFunctionCalls> <SpacesAroundInPredicateContents> <m_After>false</m_After> <m_Before>false</m_Before> </SpacesAroundInPredicateContents> <SpacesAroundParentheses> <m_After>true</m_After> <m_Before>true</m_Before> </SpacesAroundParentheses> <SpacesAroundParenthesesContents> <m_After>false</m_After> <m_Before>false</m_Before> </SpacesAroundParenthesesContents> <SpacesOrTabs>OnlySpaces</SpacesOrTabs> <SubsequentListItemsBreakType>ChopAlways</SubsequentListItemsBreakType> <UseGlobalListOptionsForDmlStatements>false</UseGlobalListOptionsForDmlStatements> <UseObjectDefinitionCase>true</UseObjectDefinitionCase> <VerticallyAlignAliases>true</VerticallyAlignAliases> <VerticallyAlignClauseItems>true</VerticallyAlignClauseItems> <VerticallyAlignColumnDefinitions>true</VerticallyAlignColumnDefinitions> <VerticallyAlignComparisonOperators>true</VerticallyAlignComparisonOperators> <VerticallyAlignDataTypes>true</VerticallyAlignDataTypes> <VerticallyAlignJoinConditionWithJoinTable>false</VerticallyAlignJoinConditionWithJoinTable> <VerticallyAlignListItemComments>true</VerticallyAlignListItemComments> <VerticallyAlignListItems>true</VerticallyAlignListItems> <WhereClauseFirstItemBreakType>Never</WhereClauseFirstItemBreakType> <WrapColumn>120</WrapColumn> <WrapLongLines>true</WrapLongLines> </LayoutOptions> / comments
  1. Community
  2. SQL Prompt
  3. SQL Format doesn't format function
These are the style settings I use:<?xml version="1.0" encoding="utf-8"?> <LayoutOptions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Format.En...
0 votes
fixed with the latest version / comments
  1. Community
  2. SQL Prompt
  3. SQL Format doesn't format function
fixed with the latest version
0 votes
12 Mar 2018 16:23:46,610 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document opened 12 Mar 2018 16:23:47,162 [1] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [db_instance].[db_name] loading skipped 12 Mar 2018 16:23:48,974 [58] WARN RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2 - Error at range (0:1): System.ArgumentNullException: Value cannot be null. Parameter name: token at Format.Engine.Formatting.RuleCollection.Rules.VerticallyLinkedTokensRuleExtensions.AlignmentPoint(VerticallyLinkedTokensRule verticallyLinkedTokensRule, TSqlParserToken token) at Format.Engine.Formatting.RuleProviders.Common.ProcedureParameterRuleProvider.AlignTo(IList`1 procedureParameters, TSqlFragment parentFragment) at Format.Engine.Formatting.RuleProviders.CreateAlterFunctionRuleProvider.ProvideForCommonFunction(TSqlFragment fragment, TSqlParserToken firstToken, TSqlParserToken asToken, TSqlFragment returnFragment, IList`1 parameters) at Format.Engine.Formatting.RuleProviders.CreateAlterFunctionRuleProvider.FormatFunctionStatementBody(FunctionStatementBody fragment) at Format.Engine.Formatting.RuleProviders.Visitors.TopLevelVisitor.Visit(CreateFunctionStatement fragment) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(CreateFunctionStatement node) at Microsoft.SqlServer.TransactSql.ScriptDom.CreateFunctionStatement.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlBatch node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlScript node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.Accept(TSqlFragmentVisitor visitor) at Format.Engine.Formatting.SqlFormatter.Format(String script, IScriptWriter scriptWriter, CancellationToken cancellationToken, IList`1& parseErrors) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, LayoutOptions activeStyle, Int32 tabSize, IList`1& formatErrors, CancellationToken cancellationToken) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, String activeStyleName, Int32 tabSize, ITextReplacer textWriter, Int32 startIndex) / comments
  1. Community
  2. SQL Prompt
  3. SQL Format doesn't format function
12 Mar 2018 16:23:46,610 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document opened 12 Mar 2018 16:23:47,162 [1] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [db_instance].[...
0 votes
Hi @Jessica R . After reboot everything started to work. Thanks / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt (with license) is not working with 2017
Hi @Jessica R . After reboot everything started to work. Thanks
0 votes
After install SQL Prompt menu disappeared from VS2017. In SSMS it works well UPDATE: After updating VS from 15.4.3 to 15.4.4 menu appeared / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.0.5.3501 (3rd January)
After install SQL Prompt menu disappeared from VS2017. In SSMS it works well UPDATE: After updating VS from 15.4.3 to 15.4.4 menu appeared
0 votes
Strange but I can't reproduce it anymore. Please close this discussion, everything seems to be working / comments
  1. Community
  2. SQL Prompt
  3. Expand wildcards does not work with Visual Studio 2015
Strange but I can't reproduce it anymore. Please close this discussion, everything seems to be working
0 votes
Hi David, after downloading the latest beta version, this problem dissappeared. / comments
  1. Community
  2. SQL Prompt
  3. Bug in formatting when transaction level is uncommitted
Hi David, after downloading the latest beta version, this problem dissappeared.
0 votes
Done. Another bug with GROUP BY suggestions. When auto-completing non aggregate columns it did not include "s.dir" : SELECT ProductId , COUNT(*) * s.dir AS Qty , NULL AS LocationId FROM dbo.SalesOrder_Product CROSS APPLY ( SELECT &#91;dbo&#93;.&#91;fn_SalesOrderProductQtyChangeSignUnit&#93;(@PreviousStatusCode, @OrderStatusCode) AS dir ) s WHERE SalesOrderId = @SalesOrderId AND s.dir IS NOT NULL GROUP BY ProductId (120,1): SQL72014: .Net SqlClient Data Provider: Msg 8120, Level 16, State 1, Procedure p_UpdateSalesOrderStatus, Line 28 Column 's.dir' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. David Priddle wrote: Hi sdks, If you could put this and any other formatting suggestions you have in our formatting survey, that would be great. We're working on upgrading the formatter so that it is more powerful and flexible, so having your suggestions would help a lot. Best regards, David / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 7.1 Beta (now closed)
Done. Another bug with GROUP BY suggestions. When auto-completing non aggregate columns it did not include "s.dir" :SELECT ProductId , COUNT(*) * s.dir AS Qty , ...
0 votes
Another bug. SHIFT+F5 does not work then there are syntax errors in the window. For example: SELECT 1 SELECT * FROM If I just highlight "SELECT 1" I can execute it. However when the cursor is somewhere between "SELECT 1" statement and hit SHIFT+F5 it gives following error: --------------------------- SQL Prompt - Execute current statement --------------------------- SQL Prompt was unable to complete this operation. Problem areas have been highlighted. --------------------------- OK --------------------------- / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 7.1 Beta (now closed)
Another bug. SHIFT+F5 does not work then there are syntax errors in the window. For example: SELECT 1 SELECT * FROM If I just highlight "SELECT 1" I can execute it. However when the cursor is som...
0 votes
Total activity
61
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
17