Posts
Sort by recent activity
SQL Prompt (with license) is not working with 2017
I have license for SQL Prompt and it works fine with VS2015. Now I've installed the VS2017 and SQL Prompt is missing. I do not have SQL Prompt menu anywhere, snippets are not working, code formatti...
Bug in sql prompt GROUP BY suggestions (8.0.5.1758)
When you set your cursor after GROUP BY and hit ctrl + space and choose "All non-aggregate columns" then it breaks the code:SELECT * FROM table1
ALTER FUNCTION [dbo].[fun] ()
returns table
return...
Expand wildcards does not work with Visual Studio 2015
If you are using Query Window then it work as expected. However if you writing query in the "object file" (for example I have project for database and there is the project file dbo->Tables->my_tabl...
Bug in formatting when transaction level is uncommitted
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
;WITH roots AS
(
SELECT
1 AS one
)
SELECT * FROM roots r
order by 1
Following code is formatted like:SET NOCOUNT ON;
SET ...
Formatting byg
Hi, wrong formatting. If you remove comment, then it formats good. I've just updated 6.6.0.180 but it was the same with 2 months earlier version
SELECT 1
FROM a
CROSS APPLY (
-- IMPORTANT C...
BUG: Wrong semicolon insert. SQL Prompt 6.4.0.657
Mainly it is working good, but I found the case where it set incorrectly
BEGIN
BEGIN TRANSACTION;
WAITFOR
(
RECEIVE TOP (1)@conversation_handle = conversation_handle,@message_body = CAST(CAST(messa...