Is there a general rule of thumb when to create a SQL Server Stored Procedure for an Execute SQL Task

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.

September 4th, 2015 4:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics