Peter Bahaa's Blog

Business and Technical Articles

Best way to send multiple values in one parameter to database

July 19
by Peter Bahaa 19. July 2010 22:20
Many time i stucked with business requirements which says we need to send multiple parameters to database, so the first thing came to my head is to send a comma separated parameter and send this parameter to a t-sql tabler function and query on the values that come out from this function which was tooooooooooooo slowwwwwwwww while ago i had this conversation with one of my colleges and he proposed X-Path which i tried it, and it was more slow and very pad performance, and another one suggested ... [More]

Tags:

Tips & Tricks | XML | T-SQL

Calendar

<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011

View posts in large calendar