Posted by Jack Vamvas on 03/21/07 20:52

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.googlegroups.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.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
>
>
>

[Back to original message]