Activity overview
Latest activity by Win32nipuh
Jon_Kirkwood said:
Hi there, I understand that the error being displayed there is coming from SQL Server directly and isn't being generated by SQL Prompt The IS NOT DISTINCT syntax is new for SQL Server 2022 & Azure SQL instances and is anticipated to throw a syntax error if executed against older versions of SQL Server. I suspect our online SQL formatter is not using SQL Server 2022 and this is why the syntax error occurs. Are you using SQL Prompt as a tool deployed to SSMS, VS or ADS on your local device? If this is the error you are receiving in your environment, then I suspect you are running this against an invalid version of SQL Server to parse this code https://learn.microsoft.com/en-us/sql/t-sql/queries/is-distinct-from-transact-sql?view=sql-server-ver16 Are you receiving any other errors than 'Incorrect syntax near distinct' when formatting your code?
Hi Jon, I do not use SQL Prompt, I am trying different tools to select what is suitable for us. We have used Poors Man formatter but it does not understand even more syntax constructions. So I have tried your online formatter and wrote the request. We need a tool for formatting T-SQL in SSMS, VS, Azure Data Studio. And also in VSC will be good but it is not mandatory for now. We are using SQL 2022 on-premise and Azure. Regards. / comments
Jon_Kirkwood said:
Hi there, I understand that the error being displayed there is coming from SQL Server directly and isn't being generated by SQL PromptThe IS NOT DISTINCT syntax is new for ...
Hi Victoria, please try in the online formatter provided by RG. What is the result? FYI: the link https://www.red-gate.com/products/sql-prompt/#format-sql / comments
Hi Victoria, please try in the online formatter provided by RG. What is the result?FYI: the link https://www.red-gate.com/products/sql-prompt/#format-sql
I click Post Comment but it disappeared and not posted. ---- I am looking for tool and try different, SQL Prompt is one of them. We have used Poors Man formatter but it does not understand even more syntax . We are working with SQL 2022 and Azure so we need the tool to format T-SQL to use it in SSMS 19-20, VS 2022, Azure Data Studio. VSC will be good. / comments
I click Post Comment but it disappeared and not posted.----I am looking for tool and try different, SQL Prompt is one of them.We have used Poors Man formatter but it does not understand even more ...
Check it here and let me know about results please: https://www.red-gate.com/products/sql-prompt/#format-sql / comments
Check it here and let me know about results please:https://www.red-gate.com/products/sql-prompt/#format-sql
SQLPrompt does not understand SQL 2022 syntax?
Try this simple SQL 2022 codedeclare @x int=1
declare @xx int=2
if @x is not distinct from @xx print '=' else print '<>' SQL Prompt generates syntax error.Can it be fixed soon?
I have checked >ping my-server 192.168.0.101 and run docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA /s1:192.168.0.101\\sql2019 /db1:database1 /u1:sa /p1:my-password /s2:192.168.0.101\\sql2019 /db2:database2 /u2:sa /p2:my-password Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) / comments
I have checked>ping my-server192.168.0.101and run docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA /s1:192.168.0.101\\sql2019 /db1:database1 /u1:sa /p1:my-password /s2:192.168.0.101\\sql2019...
Hi Roseanna, thnax, could you please look at https://forum.red-gate.com/discussion/87291/docker-cannot-connect-to-sql-server#latest I have wrote about Docker problems / comments
Hi Roseanna, thnax, could you please look at https://forum.red-gate.com/discussion/87291/docker-cannot-connect-to-sql-server#latestI have wrote about Docker problems
Docker: cannot connect to SQL Server
I tried to run the Docker as described docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA /s1:my-server\\sql2019 /db1:database1 /u1:sa /p1:my-password /s2:my-server\\sql2019 /db2:database2 /u2...
Thanx Victoria, and waiting for the fixed versions / comments
Thanx Victoria, and waiting for the fixed versions
SQL Search does not start in SSMS 18.5
I have updated SSMS to v18.5 and then uninstall SQL Search, downloaded the latest one and installed. SSMS started, I click button "SQL Search" - no any errors/exceptions but SQL Search does not sta...