So, use of Parameter in sp_executesql makes it parameterized

(defining parameter) @params = N'@ProductID integer', (value of the parameter) @ProductID = @parameter;

If only...

Thanks Paul,

So in your second SQL(Dynamic Parameterized SQL), since variable is not concatenated in WHERE condition (WHERE p.ProductID = @ProductID) is this what makes it 'Parameterized SQL'?

Thanks a lot. Is it possible for you to give me one example of each? Thanks

Thanks for the guidance. So I was not the only one with this problem.

Thank you guys, I am going through Jacb sebastians workshop and his tutorials are just phenomenal. Thanks

You said you have 5 datetime columns and about 400 results in that table right? If thats the case, is it possible for you to copy the result set of...

That seems like good home work and nice points George. Well, I do need to get same baseline stats. I really appreciate your help. Nice checklist.

Any more suggestions? Any idea will be helpful. thanks

Thats exactly what I did today, instead of top 5 I went for top 3 queries. Really appreciate your response. Thanks.

Question has the answer.

"You want to deploy SQL Server Compact Edition"