SQL Server execute statement

• Parameters fit into one line

  EXEC Sptrackmember @p_member_id,'2.2',@p_weeknum 

• Stacked parameter

  • Comma at the end of line

  EXEC Sptrackmember @p_member_id,
       '2.2',
       @p_weeknum 

  • Comma at the begin of line

  EXEC Sptrackmember @p_member_id
       ,'2.2'
       ,@p_weeknum 

  • Comma at the begin of line, align parameters.

  EXEC Sptrackmember @p_member_id
      ,'2.2'
      ,@p_weeknum 

  • Comma at the begin of line, align parameters, space between comma and variable from 1 to n

  EXEC  Sptrackmember @p_member_id
      , '2.2'
      , @p_weeknum 

• Format SQL inside string literal

  Turn this SQL:

  EXECUTE ( 'CREATE TABLE AdventureWorks.dbo.SalesTbl  
  (SalesID int, SalesName varchar(10)) ; ' ) AT seattlesales; 

  into

  EXECUTE ( 'CREATE TABLE adventureworks.dbo.salestbl  
               (salesid   INT, 
                salesname VARCHAR(10));' ) AT seattlesales;