Capturing an Output variable from SQLCMD Script

• Weegee2017

  SSC Eights!

  Points: 994

  More actions

  November 21, 2019 at 5:20 pm

  #3699716

  Hi there

  Is there a way that I can capture an output variable from a SQLCMD Script?

  For example:

  Declare @Today dateTime

  set @Today = GetDate()

   

   

   

• Phil Parkin

  SSC Guru

  Points: 246965

  More actions

  November 21, 2019 at 5:23 pm

  #3699717

  Weegee2017 wrote:

  Hi there

  Is there a way that I can capture an output variable from a SQLCMD Script?

  For example:

  Declare @Today dateTime

  set @Today = GetDate()

  What is this an example of?

  Isn't this post a duplicate of https://www.sqlservercentral.com/forums/topic/reading-a-variable-from-sqlcmd-script-back-into-a-stored-procedure?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• November 26, 2019 at 3:33 am

  This was removed by the editor as SPAM