SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Stored Procedures Reconsidered

Quite the debate going on from today's editorial: Stored Procedures Reconsidered. I chimed in late, and going on the "pro-sprocs" group. I think stored procedures are helpful, and a better idea, and most importantly:

Don't take that much more effort

You should be able to auto-gen trivial procs, and you should be able to auto-gen the stored procedure calls from .NET. Actually that's a little utility that we've considered writing before. Something you can point at a server, give it a proc name, have it sniff out the procedure parameters, types, etc. and write the code. How hard can that be?

I don't think that stored procedures are required everywhere, but I think they do provide benefits and ignoring those benefits because you don't want to write them (laziness) just doesn't make sense.



The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


No comments.

Leave a Comment

Please register or log in to leave a comment.