what's the best way to pass accepted user inputs to SP

Question

Someone please tell me the best way expert follows

Manav Pandya · Answer

Yes Venkat For XML is faster compare to other ways Thanks

Venkat Raman · Answer

@Manav But few people say if we pass XML it will be fast and secure is that true?

Manav Pandya · Answer

Hello @Venkat At last it depends on you that how you manage data But its not necessary to convert into XML  you can use (comma) or for xml Thanks

Venkat Raman · Answer

Thanks for your reply @Manav when there are multiple values is it necessary to convert it to XMlL and then pass?

Manav Pandya · Answer

Hello @Venkat From controller code you can pass parameter like : com.Parameters.AddWithValue(@ColumnColumn_value); // com is SqlCommand object And from sql server : Declare variable within SP declaration like @Column nvarchar(20); and use it like : insert into table_nm values(@Name) Thanks