Posted by plmanikandan on 03/21/07 20:26

On Mar 21, 7:45 pm, "Jack Vamvas" <DEL_TO_RE...@del.com> wrote:
> Sounds like a View
>
> --
>
> Jack Vamvas
> ___________________________________
> Advertise your IT vacancies for free at -http://www.ITjobfeed.com
>
> <plmanikan...@gmail.com> wrote in message
>
> news:1174495141.918629.74950@d57g2000hsg.googlegroups.com...
>
> > Hi,
> > I would like to know details about the table name starts with prefix
> > in sql server 2000.
> > Actually i'm working on existing code.
> > The existing code insert a record into a table, but the table name in
> > the code and table name in database are different
> > Table name in database : tbl_mmm_ox
> > In coding they are using table name as mmm only, the records are
> > properly inserted into mmm table
> > is it possible?
> > The sample code is like that(using ado object)
> > oCmd.CommandText = "INSERT INTO mmm (no,name) values (1,"mm")"
> > The above code is perfectly working and inserting record into
> > tbl_mmm_ox.
> > Could anybody explain how is it possible?
> > whether we can leave the prefix(tbl) and suffix(ox) and sql server
> > take care of this?
>
> > Thanks & Regards,
> > Mani

Thanks friends.It's view only.find that view after posting this
message.
Is it wise to use a view to insert the record.
Is there any performance issue may come due to this view.
I would like to know the opinion on this?

Thanks & Regards,
Mani

• Next in forum: Re: Table name starting with prefix tbl
• Prev in forum: Re: help with parameter in WHERE
• Thread view: Re: Table name starting with prefix tbl

[Reply to this message]