Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Format SQL Backup to URL with credential breaks code

Formatting a SQL batch which contains

BACKUP DATABASE Databasename
TO URL = N'URL'
WITH CREDENTIAL = N'Credential'

leads to

BACKUP DATABASE Databasename
TO URL = N'URL'
WITH AS CREDENTIAL = N'Credential'

the AS between with and credential is wrong.

Please fix :-)

3 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Andreas shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Chris Williamson commented  ·   ·  Report

    Adding URL should be a very simple addition.

    In addition, using multiple DISK options (and therefore multiple URL options), each option should be carried to the next line. Using URL with Azure Storage Blobs Block sizes require us to use up to 8 URL's, which get translated to 1 line (we Find/Replace URL = to DISK =, format, then Find/Replace back).