Comments
Sort by recent activity
Hi Russell,
thanks for looking into this.
Version : 8.0.0.1241
I guess the reason for miss formatting is caused by setting Parentheses/ Parentheses contents/ Place on new line / Indent parentheses contents (enabled)
Hope this helps!
Otherwise I need to send you my custom style. / comments
Hi Russell,
thanks for looking into this.
Version : 8.0.0.1241
I guess the reason for miss formatting is caused by setting Parentheses/ Parentheses contents/ Place on new line / Indent parentheses ...
Hi Michael,
honestly I think this is not an enhancement but covering the new syntax of SQL Server 2016.
I thought that "suggesting a feature" is for a feature(!) and not for missing key words in the intellisense.
What do you think?
BTW Trying to suggest a feature is not possible:
"You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas. "
Thanks in advance!
Torsten
Friend of Redgate / comments
Hi Michael,
honestly I think this is not an enhancement but covering the new syntax of SQL Server 2016.
I thought that "suggesting a feature" is for a feature(!) and not for missing key words in th...
Hi Michael,
thanks for looking into this!
Yes, I use the latest beta version.
Torsten / comments
Hi Michael,
thanks for looking into this!
Yes, I use the latest beta version.
Torsten
Hi James,
good suggestion but it would be nice to align the first line with the second one if there is more than one line. CREATE DATABASE MemoryOptimized
ON PRIMARY
(
NAME = MemoryOptimized_data
, FILENAME = '$(DataPath)MemoryOptimized_data.mdf'
, SIZE = 256MB
)
, FILEGROUP MemoryOptimized CONTAINS MEMORY_OPTIMIZED_DATA
(
NAME = MemoryOptimized_folder
, FILENAME = '$(DataPath)MemoryOptimized_folder'
)
LOG ON
(
NAME = MemoryOptimized_log
, FILENAME = '$(LogPath)MemoryOptimized_log.ldf'
, SIZE = 128MB
);
ALTER DATABASE MemoryOptimized
SET RECOVERY FULL;
GO
This is the same problem with the value formatting: INSERT Person.Address
(
AddressLine1
, AddressLine2
)
VALUES
(
-- not aligned
N'' -- AddressLine1 - nvarchar(60)
, N'' -- AddressLine2 - nvarchar(60)
);
What do you think?
Thanks for looking into this! / comments
Hi James,
good suggestion but it would be nice to align the first line with the second one if there is more than one line. CREATE DATABASE MemoryOptimized
ON PRIMARY
(
NAME...
Thanks Harry,
another example of strange formatting can be observed using this statement.
Just try to format this and I am pretty sure you will see the issues. -- create a database for demonstration purposes
USE master;
GO
IF DB_ID('InternalStorageFormat') IS NOT NULL
BEGIN
ALTER DATABASE InternalStorageFormat SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE InternalStorageFormat;
END;
GO
CREATE DATABASE InternalStorageFormat
ON PRIMARY
(
NAME = N'InternalStorageFormat'
, FILENAME = N'C:Program FilesMicrosoft SQL ServerMSSQL13.MYSQLSERVER2016MSSQLDATAInternalStorageFormat.mdf'
, SIZE = 50MB
, FILEGROWTH = 0
)
,FILEGROUP SECONDARY
(
NAME = N'InternalStorageFormat_02'
, FILENAME = N'C:Program FilesMicrosoft SQL ServerMSSQL13.MYSQLSERVER2016MSSQLDATAInternalStorageFormat_02.ndf'
, SIZE = 50MB
, FILEGROWTH = 0
)
,
(
NAME = N'InternalStorageFormat_03'
, FILENAME = N'C:Program FilesMicrosoft SQL ServerMSSQL13.MYSQLSERVER2016MSSQLDATAInternalStorageFormat_03.ndf'
, SIZE = 50MB
, FILEGROWTH = 0
)
LOG ON
(
NAME = N'InternalStorageFormat_log'
, FILENAME = N'C:Program FilesMicrosoft SQL ServerMSSQL13.MYSQLSERVER2016MSSQLDATAInternalStorageFormat_log.ldf'
, SIZE = 25MB
, FILEGROWTH = 0
);
GO
/ comments
Thanks Harry,
another example of strange formatting can be observed using this statement.
Just try to format this and I am pretty sure you will see the issues.-- create a database for demonstration...
Hi Harry,
you are right - it is caused by the formatting here in the thread [image]
SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;
will formatted to
SELECT_ * FROM_ sys.all_sql_modules WHERE_ uses_native_compilation = 1;
_ replaces the space. / comments
Hi Harry,
you are right - it is caused by the formatting here in the thread
SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;
will formatted to
SELECT_ * FROM_ sys.all_sql_modul...
It is possible for sure.
Just go to Tools / Option / Keyboard ...
Search for OtherContextMenus.SQLFilesEditorContext.ExecuteCurrentStatement and assign Ctrl + Enter as a global shortcut key.
This will work for SSMS and Visual Studion. / comments
It is possible for sure.
Just go to Tools / Option / Keyboard ...
Search for OtherContextMenus.SQLFilesEditorContext.ExecuteCurrentStatement and assign Ctrl + Enter as a global shortcut key.
This w...
Hi James!
It seems that in memory DDL statements are not supported currently in most of the cases
Would be cool to see this in the next release...
Thanks!
Another example:
ALTER TABLE dbo.Product
--no intelliSense
ALTER INDEX PK__Product__357D0D3F0107568F REBUILD WITH(BUCKET_COUNT = 32);
GO / comments
Hi James!
It seems that in memory DDL statements are not supported currently in most of the cases
Would be cool to see this in the next release...
Thanks!
Another example:
ALTER TABLE dbo.Product
-...
Honestly I consider this as some kind of bug rather than a formatting enhancement.
I use the function a lot during presentation and whenever I need to reformat the entire code this function causes Redgate (and MS intellisense) to fail which will draw the attention of the audience to Redgate SQL Prompt in a negative way...
Despite of the fact that the function is not officially supported it would be nice to see the implementation in some of the next releases without the survey beforehand.
Many thanks for your support! / comments
Honestly I consider this as some kind of bug rather than a formatting enhancement.
I use the function a lot during presentation and whenever I need to reformat the entire code this function causes ...
Hi David!
Sent! Happy debugging!
Torsten / comments
Hi David!
Sent! Happy debugging!
Torsten