How can we help you today?

How can we help you today?

Partition function

Hi Redgate Team,

SQL Prompt will add an additional space before the data type which is not needed.

Thanks for fixing!

Torsten
MVP

-- Create a partition function

CREATE PARTITION FUNCTION pf (date) -- pf__(date)

AS RANGE LEFT FOR VALUES

(

'20090101'

, '20100101'

, '20110101'

, '20120101'

, '20130101'

, '20140101'

, '20150101'

, '20160101'

, '20170101'

, '20180101'

, '20190101'

);

GO

torsten.strauss November 11, 2019 18:28

0

Comments

4 comments

Hi Tortsten,

Thank you for reporting this to us!

This doesn't seem to be a bug as having a space before the datatype seems to be the typical way of styling this (e.g., the examples on Microsoft's docs page: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-partition-function-transact-sql?view=sql-server-ver15).

However if you wish to remove the space then please submit a feature request on the UserVoice forum.

I hope this has been helpful,
Dan

DanC November 13, 2019 11:40

0
Hi Dan,

there are two spaces...

torsten.strauss November 13, 2019 12:00

0
Hi Torsten,

I'm only getting one space when formatting the SQL using your script style and the default.

Thanks,
Dan

DanC November 13, 2019 12:40

0
Hi Dan,

I can see two spaces ....

torsten.strauss November 14, 2019 16:33

0

Add comment

Please sign in to leave a comment.