且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将条件批处理数据发送到SQL Server的正确方法是什么

更新时间:2023-02-03 15:44:50

用作本文的例子



sql-server-helper.com

I have to send batch data to server by checking data so i wants to know
Which is proper way to send Conditional batch data in sql server
1. Comma separated values
2. UDT
3. One by one
Using 1 is i looks easy but is it professional
Using UDT I dont know much about it
Using one by one isnot secure as if any data fails then transaction how to achieve
So please tell me which is proper way ?

Use as the examples of this article

sql-server-helper.com