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

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

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.




No comments.

Leave a Comment

Please register or log in to leave a comment.