Activity overview
Latest activity by PawJ
Cross Apply blocks "Tab to expand wildcard"
Promt Version: 10.16.3.14709We have this very simple code, were we cannot use the Tab to expand wildcardCode Example:SELECT *
FROM [sys].[indexes] [i]
JOIN [sys].[stats] [s] ON [s].[object_id] = [...
Hey Jon Just posted this on uservoice: IntelliSense for $partition. – Customer Feedback for Redgate (uservoice.com) / comments
Hey JonJust posted this on uservoice: IntelliSense for $partition. – Customer Feedback for Redgate (uservoice.com)
Intellisense for $partition.<partition_functions>
Im missing Intellisense for working with partitioning in SQL Server.I would like the Prompt to be able to list any partition function found in the current context (DB)like when i write: $partition....
Hi Ben But it wasn't what I asked for! I requested a CLR function to prepare scripts using a function.
However, you are asking me for the following:
Export my code to a file
Starting the application up and bulk format the folder
Importing the formatted code file
Saving the script..
This appears to be quite thorough.
But it's fine if you don't see the use case and decide not to implement this functionality... / comments
Hi BenBut it wasn't what I asked for!I requested a CLR function to prepare scripts using a function.
However, you are asking me for the following:
Export my code to a file
Starting the application...
When in a query window, we can right click and choose Format SQL. There is a bulk method shown here: https://www.red-gate.com/hub/product-learning/sql-prompt/bulk-formatting-of-the-sql-server-sql-files. "i would prefer if i could stay in code" So what I would like to have is a CLR function where I could do the same, like: SELECT [master].[redgate].format_sql(@expression, @style, ... ) / comments
When in a query window, we can right click and choose Format SQL.There is a bulk method shown here: https://www.red-gate.com/hub/product-learning/sql-prompt/bulk-formatting-of-the-sql-server-sql-fi...
SQL Format as CLR function
Would it be possible to make the SQL Format available via an CLR function on the sql server
Intellisense for Extended Events
Would it be possible to add the IntelliSense for use when writing Events ?? like when you are writing:CREATE EVENT SESSION [my_session] ON SERVER
ADD EVENT <*intelliSense_should_start_here*>first ...
Hey Jon Thanks for the reply, sadly im not able to fix it with your'e suggestion, this is what i get [image] I do the refresh (also tried to restart SSMS) But still I only get this [image] / comments
Hey JonThanks for the reply, sadly im not able to fix it with your'e suggestion, this is what i getI do the refresh (also tried to restart SSMS)But still I only get this
Incorrect Temp table definition
In the latest version (i dont know if it always was like this) 10.11.2.26629 of SQL Promt, i get incorrect temp table definition when i use this code:USE [distribution];
DROP TABLE IF EXISTS #test_...