Item logo image for SQL Viewer

SQL Viewer

3.8(

5 ratings

)
ExtensionDeveloper Tools7,000 users

1 support issue

  • All
  • Questions
  • Suggestions
  • Problems

Eric Osmann

Jan 29, 2024

Multiple commands or instructions all on one line

Is there a NO Format mode you can provide?
The default behavior is completely messing up the script for both running and readability
Such as

IF dbo.dbProcedureExists('RBC_sp_Imports_Load_RBCMMR_Daily') = 1 DROP PROCEDURE RBC_sp_Imports_Load_RBCMMR_Daily

Where the following instruction is appended to the same line. I realize that the code may not be written to spec but this is why a RAW feature would be nice. Currently, I see no option that will show the code in its original form on the screen.

Here is another example where the DECLARES are all appended to the end of the UPDATE command:
--Update Fund ID's
UPDATE
Import
SET
Import.ShareClassID = SC.AutoID
FROM
fs_ShareClasses_v2 SC,
RBC_Imports_RBCMMR_Daily Import
WHERE
Import.Share_Class_Cusip = SC.CUSIP DECLARE @ImportDate datetime DECLARE @DateMonthly datetime DECLARE @EndOfLastMonth datetime --Check auth table for date and Fund entry if does not exist add entry for date and all funds to all Dynamic FCD tables using fs_sp_FCD_Insert_DateRows
SELECT
TOP 1 @ImportDate = [Date]

Google apps