When we have to pass multiple rows of data to SQL Server the
developers either have to send one row at a time or come up with other
workarounds to meet requirements like using XML datatype to pass data which is
a bit complex and tedious to use. Also there is a SQLBulkCopy object available
in .Net to send multiple rows of data to SQL Server at once, but the data still
can not be passed to a stored procedure.