Posted by Jack Vamvas on 03/21/07 19:45

Sounds like a View

--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com



<plmanikandan@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
>

• Next in forum: Re: Accessing external data from SQL Server
• Prev in forum: Re: help with parameter in WHERE
• Thread view: Re: Table name starting with prefix tbl

[Reply to this message]