Table name starting with prefix tbl

**AlterEgo** · Mar 21 '07, 05:35 PM

Re: Table name starting with prefix tbl

Mani,

Someone probably created a view called mmm that points to the tbl_mmm_ox
physical table.

-- Bill

<plmanikandan@g mail.comwrote in message
news:1174495141 .918629.74950@d 57g2000hsg.goog legroups.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.CommandTex t = "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
>

**Jack Vamvas** · Mar 21 '07, 07:55 PM

Re: Table name starting with prefix tbl

Sounds like a View

--

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

<plmanikandan@g mail.comwrote in message
news:1174495141 .918629.74950@d 57g2000hsg.goog legroups.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.CommandTex t = "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
>

**plmanikandan@gmail.com** · Mar 21 '07, 08:35 PM

Re: Table name starting with prefix tbl

On Mar 21, 7:45 pm, "Jack Vamvas" <DEL_TO_RE...@d el.comwrote:

Sounds like a View
>
--
>
Jack Vamvas
_______________ _______________ _____
Advertise your IT vacancies for free at -http://www.ITjobfeed.c om
>
<plmanikan...@g mail.comwrote in message
>
news:1174495141 .918629.74950@d 57g2000hsg.goog legroups.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.CommandTex t = "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

**Jack Vamvas** · Mar 21 '07, 08:55 PM

Re: Table name starting with prefix tbl

what would be the goal of inserting via the VIEW rather than inserting into
the underlying tables?
it depends on the complexity and who your users are?

--

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

<plmanikandan@g mail.comwrote in message
news:1174508793 .879342.208410@ e65g2000hsc.goo glegroups.com.. .

On Mar 21, 7:45 pm, "Jack Vamvas" <DEL_TO_RE...@d el.comwrote:

>Sounds like a View
>>
>--
>>
>Jack Vamvas
>______________ _______________ ______
>Advertise your IT vacancies for free at -http://www.ITjobfeed.c om
>>
><plmanikan...@ gmail.comwrote in message
>>
>news:117449514 1.918629.74950@ d57g2000hsg.goo glegroups.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.CommandTex t = "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
>
>
>

**Roy Harvey** · Mar 21 '07, 10:05 PM

Re: Table name starting with prefix tbl

On Wed, 21 Mar 2007 20:52:37 -0000, "Jack Vamvas"
<DEL_TO_REPLY@d el.comwrote:

>what would be the goal of inserting via the VIEW rather than inserting into
>the underlying tables?
>it depends on the complexity and who your users are?

I rather suspect the reason for the views in this particular case was
to be able to avoid the silly tbl prefix and _ox suffix without
breaking something else.

Roy Harvey
Beacon Falls, CT

**Hugo Kornelis** · Mar 21 '07, 10:55 PM

Re: Table name starting with prefix tbl

On 21 Mar 2007 13:26:33 -0700, plmanikandan@gm ail.com wrote:

(snip)

>Is it wise to use a view to insert the record.

Hi Mani,

A common reason to do this is if the table holds more columns than the
view. For instance audit columns, that are filled with a DEFAULT
constraint and that should not be overwritten by the INSERT statement.

>Is there any performance issue may come due to this view.

Probably not, but it depends on how the view is defined, if it's updated
through a trigger and if so, how the trigger is written.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

**DickChristoph** · Mar 26 '07, 03:05 AM

Re: Table name starting with prefix tbl

Hi

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?

Well you can set up partitioned Views when the view is the Union of many
tables. The tables can then be stored on multiple physical drives. and the
partioning takes care of putting the data in the right table based on the
partioning column.

-Dick Christoph

<plmanikandan@g mail.comwrote in message
news:1174508793 .879342.208410@ e65g2000hsc.goo glegroups.com.. .

On Mar 21, 7:45 pm, "Jack Vamvas" <DEL_TO_RE...@d el.comwrote:

>Sounds like a View
>>
>--
>>
>Jack Vamvas
>______________ _______________ ______
>Advertise your IT vacancies for free at -http://www.ITjobfeed.c om
>>
><plmanikan...@ gmail.comwrote in message
>>
>news:117449514 1.918629.74950@ d57g2000hsg.goo glegroups.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.CommandTex t = "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
>
>
>

Table name starting with prefix tbl

Table name starting with prefix tbl

Comment

Comment

Comment

Comment

Comment

Comment

Comment