SEO

#1 (**permalink**) 03-01-2008, 01:43 PM

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

#2 (**permalink**) 03-01-2008, 01:43 PM

Mani,

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

-- Bill

<plmanikandan@gmail.com> wrote in message
news:1174495141.918629.74950@d57g2000hsg.googlegro ups.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
>

#3 (**permalink**) 03-01-2008, 01:44 PM

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.googlegro ups.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
>

#4 (**permalink**) 03-01-2008, 01:44 PM

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.googlegro ups.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

#5 (**permalink**) 03-01-2008, 01:44 PM

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@gmail.com> wrote in message
news:1174508793.879342.208410@e65g2000hsc.googlegr oups.com...
> 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.googlegro ups.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
>
>
>

#6 (**permalink**) 03-01-2008, 01:44 PM

On Wed, 21 Mar 2007 20:52:37 -0000, "Jack Vamvas"
<DEL_TO_REPLY@del.com> wrote:

>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

#7 (**permalink**) 03-01-2008, 01:44 PM

On 21 Mar 2007 13:26:33 -0700, plmanikandan@gmail.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

#8 (**permalink**) 03-01-2008, 01:45 PM

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@gmail.com> wrote in message
news:1174508793.879342.208410@e65g2000hsc.googlegr oups.com...
> 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.googlegro ups.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
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Table name starting with prefix tbl