Passing List to SQL Stored Procedure

by

If going to SQL Server 2008 is an option for you, there’s a new feature called “Table-valued parameters” to solve this exact problem.

Check out more details on TVP here and here or just ask Google for “SQL Server 2008 table-valued parameters” – you’ll find plenty of info and samples.

Highly recommended – if you can move to SQL Server 2008…

More Related Contents:

  1. Procedure or function xxxxx has too many arguments specified [duplicate]
  2. How to pass an array into a SQL Server stored procedure
  3. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  4. SQL error: Incorrect syntax near the keyword ‘User’
  5. What represents a double in sql server?
  6. Generate class from database table
  7. What is passing parameters to SQL and why do I need it?
  8. Add WHERE clauses to SQL dynamically / programmatically
  9. How to pass a null variable to a SQL Stored Procedure from C#.net code
  10. Generating sql code programmatically
  11. How can I round a value in SQL
  12. How do I update a value in C# and SQL Server? [closed]
  13. Insert results of a stored procedure into a temporary table
  14. How to pass table value parameters to stored procedure from .net code
  15. How to get last inserted id?
  16. Call a stored procedure with parameter in c#
  17. Calling stored procedure with return value
  18. Execute Insert command and return inserted Id in Sql
  19. Adding multiple parameterized variables to a database in c#
  20. Getting data from stored procedure with Entity Framework
  21. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  22. What is a stored procedure?
  23. SQL WHERE clause matching values with trailing spaces
  24. SqlBulkCopy from a List
  25. Use of SqlParameter in SQL LIKE clause not working
  26. WHERE IN (array of IDs)
  27. SqlConnection.Close() inside using statement
  28. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  29. Eliminate and reduce overlapping date ranges
  30. How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?

Leave a Comment