Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82

    Unanswered: Looking for SQL editor that easy finds related begin to end

    Hello,

    do you know some editor (free) that in long bad written sql scripts highlight related begin/ends?

    Thanks for hint

    David

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Maybe the Instant SQL Formatter can help
    Paste your bad
    Code:
    if 1=2
    begin
      select case when 2=2 then 1
    end
    if 2=2 begin select 2 
    end else select 3 end
    else select 4
    choose MSSQL as database and SQL text as output
    click on Format SQL and you get
    Code:
    IF 1 = 2
      BEGIN
        SELECT CASE 
                 WHEN 2 = 2 THEN 1
               END
        
        IF 2 = 2
          BEGIN
            SELECT 2
          END
        ELSE
          SELECT 3
      END
    ELSE
      SELECT 4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •