-Kevin
On Wed, 21 Jul 2004 11:02:32 -0500, Kevin Graeme <[EMAIL PROTECTED]> wrote:
> Deanna makes me drop the underscore because she hates typing them. So
> rowid instead of row_id.
>
> -Kevin
>
>
>
> On Wed, 21 Jul 2004 11:58:51 -0400, Ben Doom <[EMAIL PROTECTED]> wrote:
> > We used to do something similar, but ran into problems when we had to
> > always alias the id on joins. Basically, it was a PITA, the aliases
> > weren't consistent, you had to remember if you'd used a join, you had to
> > change your output should you need to add a join.....
> >
> > Yeah. We do ours by tablename, generally, now.
> >
> > --Ben
> >
> > Marlon Moyer wrote:
> >
> > > Warning! : Silly question..
> > >
> > >
> > >
> > > I use identity fields in MSSql as my primary key. I'm getting ready to
> > > create a new database and was about to name my primary key field. In the
> > > past, I've based the name on the table name, ie on table orders, order_id.
> > > Sometimes that results in some long field names. So, does anyone see a
> > > downside to naming it a simple "id" or maybe "rowid" or "r_id" or something
> > > similar?
> > >
> > > Marlon
> > >
> >
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
