you can handle very complex business logic with 1st class programming language. SQL sometime limited.
【在 w********i 的大作中提到】 : All, : I wonder if there is benefits for performance for Writing CLR Stored : Procedures in C# ? Thank you! : hai
k*n
7 楼
1st class programming language? 难道不是只能用vb.net
w*i
8 楼
More details or examples? I thought it is not useful and sometimes it brings troubles. Thank you!
x*n
9 楼
No. CLR stored procedure is just the database team's effort to get more work /bonus. It doesn't help your performance at all because the database is not designed to do such things. The best place to place your business logic is still your middle tier.