Posts by Jaderson Linhares • 66 points

• 5

  votes

  5

  answers

  25936

  views

  A: How to pass a list of values to a Stored Procedure?

  You can pass tables as parameters. First create the TABLE TYPE: CREATE TYPE IntegerTableType AS TABLE (Id INT) When creating the past, you can use this pattern: CREATE PROCEDURE pr_lista_produtos…

  sql-server list parameters stored-procedures

  answered 9 years, 10 months ago Jaderson Linhares 66