So sometimes I'll create a SQL Server Stored Procedure...sometimes I'll just write raw SQL in my Execute SQL Task.
Is there any general rule of thumb as to when to create a SQL Server Stored Procedure and when using raw SQL is alright when utilizing an Execute SQL Task? Would have it have anything to do with re-usability which would dictate a SQL Server Stored Procedure...is either one more efficient...
Thanks for your review and am hopeful for a reply.
- Changed type ArthurZMVP, Moderator Friday, September 04, 2015 7:30 PM