Passing Table Valued Parameters to SQL Server Stored Procedures
Can also be used to pass arrays to SQL Server
1) Improves performance
2) Easy to Handle
3) Get Rids of Changing Comma Separated values to table in SQL.
1) Works only with SQL Server 2008 and above
http://msdn.microsoft.com/en-us/library/bb675163.aspx
http://www.dotnetspeaks.com/DisplayArticle.aspx?ID=47
No comments:
Post a Comment