RE: Dynamic queries v/s Stored Procs

2006-02-28 Thread rtroiana
sql string embedded in C# code? Thanks, Reema -Original Message- From: James Black [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 10:54 AM To: rtroiana Subject: Re: Dynamic queries v/s Stored Procs -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 rtroiana wrote: > Al

Dynamic queries v/s Stored Procs

2006-02-28 Thread rtroiana
I'm in a process of transitioning from dynamic queries that were generated in C# code to using Stored Procedures. Although i haven't done any analysis of time difference between the two. But i do have few reasons to move to stored procedures: 1) I work on a security application and i heard of S