Sample Header Ad - 728x90

TVP vs JSON vs XML as input parameters in SQL Server

8 votes
2 answers
2173 views
I've found that using TVPs to pass multiple values to a stored procedure is much easier and faster, especially when dealing with a few columns and a few hundred rows, as it eliminates the need for additional data parsing. Why might someone choose XML or JSON over TVPs? In what use cases do they offer better performance or advantages? Given a chance, what would you choose between the three? Thanks!
Asked by lifeisajourney (751 rep)
Jan 25, 2025, 08:29 AM
Last activity: Jan 27, 2025, 03:40 PM