Search
-
OVER (ORDER BY) breaks suggestions and code formatting
The following T-SQL breaks suggestions and formatting in SQL Prompt. There are no suggestions for #temp and val is not qualified when formatting. CREATE TABLE #temp ( val int NOT NULL ); SELECT val, LAG(val) OVER (ORDER BY val) AS prev_val FROM #temp AS t; The following two code blocks do not break suggestions and… -
Always "An item with the same key has already been added."
Discussion by rnpi · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI don't know what happened, but sometime yesterday my system stopped being able to compare itself to the database. Now when I choose "Commit Changes" or "Get Latest" there is a short period where the system displays an error dialog which says "An item with the same key has already been added." This happens when attempting… -
Expanding wildcard for @table variables not displaying computed columns
The expand wildcard feature is not working for @table variables. If I declare a @table with computed columns, then expand the wildcard, only the non-computed columns will be shown. For example: declare @t table ( C1 varchar(9) ,C2 as ('a' + C1) ,C3 as ('z') ) select * from @t If I expand the asterisk, it'll show: select C1… -
Re: Dead in the water -- latest version of SC "There was an error parsing the file "C:\:...."
What version of SQL Server? Window is a reserved word: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16 You can't use that as an identifier -
Re: What objects are not supported in the Base Line and Migrations ?
i have done this , but consistently get this error . in SSMS and SCA 4 RedGate.Versioning.Client.VsShell.Ssms.Models.Observable.UnhandledObserverException: A subscribed observable threw an unhandled exception: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set… -
Error when trying to commit changes
Discussion by atalbot · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsWhen I click on the tab to Commit Changes the wait wheel get to "Calculating Changes" and then errors out with the following error: System.Data.SqlClient.SqlException: Line 31: Incorrect syntax near '.'. Line 58: Incorrect syntax near '('. Line 62: Incorrect syntax near ','. Incorrect syntax near the keyword 'AND'. at… -
ctrl-click functionality to get to proc or else ctrl-shift-t
Hi Just installed your product. Can't ctrl-click to navigate to a called procedure when inside the editor. Would have thought this was an obvious feature so wondering whether I'm missing something?? Also would like a key combination that takes me to a stored proc in the project. Tried ctrl-T or ctrl-shift-T and they work… -
Multiple Formats
Our T-SQL Dev standards have very specific requirements for the formatting of T-SQL. I've created a custom style for this. However, I prefer to actually write T-SQL with a different style. Does SQLPrompt5 support multiple style selections? If I right click in the query window (SSMS 2012) I only have 1 choice for Format… -
prompt AI+ makes ssms close down (not answered)
Hello there, I've just upgrade my SQL Prompt to version 10.14.11.7894, now when i highlight some code a small ai+ icon appear, if i click it the prompt opens but if i click out of it, my whole SSMS closes down. Is there anything i can do to disable this "feature" of the ai+ icon appearing? i do not like it, and i do not… -
Take back up of T-SQL Scripts from Red Gate Project
i have written T-SQL Scripts for each column of the table for data generation. How do i take a back up of this scripts? I would like to save this scripts in .sql format
>1648 results
