Reply to Re: Table name starting with prefix tbl

Your name:

Reply:


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
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация