Activity overview
Latest activity by hafnera
Creating Window Handle Error
We are using SQL Source Control 5.4.2.4269 and trying to check some stored procedures into our TFS repo but when we go to the 'Commit' tab we are receiving the following error:
"Error creating wind...
That is a good catch! I stared at those statements forever and never noticed it! It is possible that the "Apply casing options" feature could do some deeper analysis when the JSON statements are used so that it does not change case on things like that? I prefer the casing options, but it is a paint to have to run SQL prompt and then go back and correct the casing stuff manually. / comments
That is a good catch! I stared at those statements forever and never noticed it! It is possible that the "Apply casing options" feature could do some deeper analysis when the JSON statements are ...
Formatted JSON Statement Causes Error
I am getting some errors when I format code using SQL Prompt 7.3.0.775 on SQL 2016 using the JSON FOR syntax. Here is some example code:
This code works:
DROP TABLE IF EXISTS #Test
CREATE TABLE #T...
Harry,
Enabling the new formatting styles resolved my issue. Thanks for the resolution! / comments
Harry,
Enabling the new formatting styles resolved my issue. Thanks for the resolution!
Ali, this is still an issue and I am on 7.3. Any idea on when this will be fixed? Here is an example of what is still breaking. Thanks!
CREATE TABLE #temp
(
test VARCHAR(20)
)
DROP TABLE IF EXISTS #temp / comments
Ali, this is still an issue and I am on 7.3. Any idea on when this will be fixed? Here is an example of what is still breaking. Thanks!
CREATE TABLE #temp
(
test VARCHAR(20)
)
DROP TABLE IF EXIS...
7.3.587 Beta Bug - Selective Reformat Not Functioning
I just downloaded the 7.3.587 beta and noticed that I am no longer able to select a specific part of a SQL statement to have it reformatted. I can highlight the statement, then select 'Format SQL'...
I love the new "Inline Stored Procedure" functionality. However, it appears it is only available when you right click on the name of the SP when you have EXEC <SP Name>. It would be nice if you could initiate this functionality any time you reference the stored procedure. So if it is proceeded by 'ALTER PROCEDURE', 'CREATE PROC', or if you right click on the stored procedure from within the SSMS tree (ie Server>Databaseses>DatabaseName>Programmability>Stored Procedures). I don't know if this is something to put on UserVoice or if it could be added as part of the existing request and included in the next Beta? Just a thought. / comments
I love the new "Inline Stored Procedure" functionality. However, it appears it is only available when you right click on the name of the SP when you have EXEC <SP Name>. It would be nice if you c...
I have a query that is over 2000 lines long and when I go to 'Format SQL' it won't run as it says "Error laying out sql" and it highlights the first letter in the first line of the SQL. However, if I run the format command on individual parts of the statement in sections, it works fine. It just doesn't work when it is run across the entire script. This did not occur before I updated to the 7.3 beta. It occurred on 7.3.450 and 7.3.460. I should also mention that the entire script can be run against SQL just fine, so there is not a syntax issue with the script. / comments
I have a query that is over 2000 lines long and when I go to 'Format SQL' it won't run as it says "Error laying out sql" and it highlights the first letter in the first line of the SQL. However, ...
Alias adds additional alias incorrectly
I really like the feature for auto aliasing tables, but I noticed an issue where if I have a table that already is aliased and then change the table it generates another alias instead of replacing ...
That worked perfectly! Thanks! / comments
That worked perfectly! Thanks!