Author Topic: Trying to beautify TSQL  (Read 558 times)

AronsonAa

  • Junior Community Member
  • Posts: 3
  • Hero Points: 0
Trying to beautify TSQL
« on: February 21, 2018, 09:19:09 pm »
I know that beautify of SQL is not supported (Been asked for many times), but I wonder if perhaps some segment of beautify can be implemented.  I'm specifically looking to take a selection of lines and format them such that I can use Column Cut/Paste on the selection.

Example:

CREATE TABLE [dbo].[XTEMP](
        [INST] [int] NOT NULL,
        [CUST_NO] [bigint] NOT NULL,
        [EMAIL_ADDR] [varchar](255) NOT NULL,
        [EMAIL_TYPE] [varchar](255) NULL,
        [STATUS] [int] NULL,
        [SRCE] [varchar](255) NULL,
        [LAST_USE] [bigint] NULL,
        [LAST_UPDT] [bigint] NULL,
) ON [PRIMARY]

CREATE TABLE [dbo].[XTemp](
        [INST]                          [int]                     NOT     NULL,
        [CUST_NO]                   [bigint]                 NOT     NULL,
        [EMAIL_ADDR]              [varchar](255)      NOT     NULL,
        [EMAIL_TYPE]               [varchar](255)                  NULL,
        [STATUS]                     [int]                                 NULL,
        [SRCE]                         [varchar](255)                  NULL,
        [LAST_USE]                  [bigint]                             NULL,
        [LAST_UPDT]                [bigint]                             NULL,
) ON [PRIMARY]

Anyone have any thoughts or Macros that will get me close to this ?


DottieMorr1

  • New Community Member
  • Posts: 1
  • Hero Points: 0
Re: Trying to beautify TSQL
« Reply #1 on: September 11, 2018, 06:09:11 am »
I am dottie morr working with 5 Days Sold. A place where you can Sell my house fast calgary within 5 days and we'll get the cash. 5 Days sold is the best solutions. We are the cash house buyers in calgary.  We are known as the companies that buy houses in any condition. Foreclosure help calgary is our work.