Comments
Sort by recent activity
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 ...
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, ...
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...
That worked perfectly! Thanks! / comments
That worked perfectly! Thanks!