How to make SQL reformat chop parameters in sproc invocation?
Answered
I want to format some SQL approximately like this:
EXEC sp_executesql
@sql,
@paramList,
@principalUserId,
@fullTextPredicate,
@projectIds,
@projectGroupId,
@createdByUserId,
@isPrivate,
@archived,
@statuses,
@priorities,
@categoryIds,
@causeIds,
@locationIds,
@responsibleUser,
@reporterCompanyIds,
@reporterCompanyRoleIds,
@relatedCompanies,
@fullTextSearchTermProjectObservationId,
@happenedAtAfter,
@happenedAtBefore,
@offset,
@limit
However, I can't find any setting to control this; I only get this with auto-formatting
EXEC sp_executesql @sql, @paramList, @principalUserId, @fullTextPredicate, @projectIds, @projectGroupId,
@createdByUserId, @isPrivate, @archived, @statuses, @priorities, @categoryIds, @causeIds, @locationIds,
@responsibleUser, @reporterCompanyIds, @reporterCompanyRoleIds, @relatedCompanies,
@fullTextSearchTermProjectObservationId, @happenedAtAfter, @happenedAtBefore, @offset, @limit
Is there any way I can make auto-format produce chopped parameters when executing stored procedures?
Please sign in to leave a comment.
Hi,
There is no such an option. Please feel free to file a feature request in JetBrains tracker: https://youtrack.jetbrains.com/issues/DBE.
K.R.
Sofia
https://youtrack.jetbrains.com/issue/DBE-14510
Thank you!