How to skip space in a SQL query

Question

I am trying to alter credentials using this SQL query:

ALTER CREDENTIAL credential_name WITH IDENTITY = 'identity_name'
  [ , SECRET = 'secret' ]

And the issue is that my credential_name has a space in it. So that would make my query look something like:

ALTER CREDENTIAL HCC SQL WITH IDENTITY = 'username', SECRET = 'password';

Running this, I get these errors:

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'SQL'.

Msg 319, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

So I was wondering if there is a way to skip the space in this query?

Or would I have to change my credential_name to something with no spaces?

esqew · Accepted Answer · 2021-02-26 20:32:48Z

2

As with most entity names in SQL Server, you can use square brackets around your credential's name:

ALTER CREDENTIAL [HCC SQL] WITH IDENTITY = 'username', SECRET = 'password';

This works in my local instance of SQL Server 15.

answered Feb 26, 2021 at 20:32

esqew

45k28 gold badges139 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to skip space in a SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related