I'm looking for an option to comment/uncomment a particular part of the query with the Slash Star Comment option.
While debugging the queries with N numbers of
JOINs, I comment out each table in the join and its related conditions one by one and find which table causing the issue or wrong data. If the commented table didn't cause the issue, I will uncomment the table and its related condition and try with the next table.
For this purpose currently I manually add -- comment in front of the particular line or press Ctrl + C to comment the entire line, if the select/conditions are in middle of the line, I move the select/condition alone to the next line and add -- comment. If there is no issues with the join, again I undo the changes or Ctrl + U to uncomment.
Moving the condition to the new line and adding the comment is burden to me, some time it caused bad alignment too.
What I want is need some shortcut key to add the
/* in front and
*/ in end of the selected text.
The below is the sample case, which my query looks like (in actual it may contain more select columns, tables and conditions).
SELECT T1.Id, T1.Name, T1.Designation, T1.CreatedDate, T2.AccountName, T3.LinkId, T3.LinkName, T4.OwnershipName FROM TableOne T1 INNER JOIN TableTwo T2 ON T2.Id = T1.Id AND T2.Name = T1.Name INNER JOIN TableThree T3 ON T3.Id = T2.Id AND T3.IsActive = 1 INNER JOIN TableFour T4 ON T4.Id = T1.Id AND T4.LinkId = T3.LinkId AND T4.IsActive = 1 WHERE T1.CreatedDate BETWEEN @FromDate AND @ToDate AND T1.DeletedDate IS NULL AND T2.DeletedDate IS NULL AND T3.DeletedDate IS NULL AND T4.DeletedDate IS NULL
Here if I want to comment the
TableThree and its related content in the
JOIN and conditions in
WHERE. I will select the content and press the shortcut key to add the
/* */ comment separately.
Expected the behavior is:
SELECT T1.Id, T1.Name, T1.Designation, T1.CreatedDate, T2.AccountName/*, T3.LinkId, T3.LinkName*/, T4.OwnershipName FROM TableOne T1 INNER JOIN TableTwo T2 ON T2.Id = T1.Id AND T2.Name = T1.Name /*INNER JOIN TableThree T3 ON T3.Id = T2.Id AND T3.IsActive = 1*/ INNER JOIN TableFour T4 ON T4.Id = T1.Id /*AND T4.LinkId = T3.LinkId*/ AND T4.IsActive = 1 WHERE T1.CreatedDate BETWEEN @FromDate AND @ToDate AND T1.DeletedDate IS NULL AND T2.DeletedDate IS NULL /*AND T3.DeletedDate IS NULL*/ AND T4.DeletedDate IS NULL