t-sql 2012 pass parameters

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  January 17, 2014 at 2:12 pm

  #302870

  I would like to know how to execute straight t-sql in sql server 2012 from ssis manager that passes 3 parameters to the sql listed below:

  Baiscally the sql looks like the following:

  Select * from customer_table

  where customer_name = @custname and customer_number = @custnumber

  and customer_state = @custstate.

  @custname is varchar(30), @custnumber is varchar(10), and @custstate is varchar(02)

  Thus can show me the sql that will run the sql listed above?

• WolfgangE

  SSCertifiable

  Points: 6328

  More actions

  January 18, 2014 at 4:21 am

  #1681323

  -- declare the variables

  declare @custname is varchar(30)

  ,@custnumber is varchar(10)

  ,@custstate is varchar(02)

  ;

  -- set values for the variables

  set @custname = 'SomeName';

  set @custnumber = '0012345';

  set @custstate = 'AB';

  -- execute the query

  Select * from customer_table

  where customer_name = @custname

  and customer_number = @custnumber

  and customer_state = @custstate;