Mark Breen
marklbreen at gmail.com
Sat Nov 28 08:27:07 CST 2009
Haha, My kids call some people by their first name and I still call the same people Mr Dowling, sounds funny to hear it. Mark 2009/11/27 jwcolby <jwcolby at colbyconsulting.com> > > I can imagine that Mr Colby will find a use for a standard piece of his > arsenal to have a in-out > param and once he does, he will wonder how we ever existing without > utilizing that aspect of params. > > LOL. Your confidence is encouraging. ;) > > While I use "by reference" values in normal programming, it is rare that I > actually modify the > passed in value. But it is something that can theoretically be useful and > so it is nice to know it > is available. > > > "Mr Colby" > > I assume you are either feeling particularly young this week or you > discovered how old I actually > am? ;) > > All of my kid's friends call me "Mr. Colby". Have you been hanging out > with Robbie? > > John W. Colby > www.ColbyConsulting.com > > > Mark Breen wrote: > > Hello Gustav, > > > > I presume they are not costly in terms of resources, and in fact, I would > > not dream of re-using a param for two different purposes. > > > > I think my delight was just that I never know you could share directions. > > > > I can imagine that Mr Colby will find a use for a standard piece of his > > arsenal to have a in-out param and once he does, he will wonder how we > ever > > existing without utilising that aspect of params. > > > > Perhaps lastupdated as a field would be an appropriate use, where the > last > > updated value is passed in to the sproc, and then passed back again with > the > > new value after an update has been made, after checking for concurrency > > errors first. > > > > Thanks > > > > Mark > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >