Posted by Hugo Kornelis on 03/21/07 22:53

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

• Next in forum: Re: help with parameter in WHERE
• Prev in forum: Re: Database table data modifications with PK/FK relationship
• Thread view: Re: Table name starting with prefix tbl

[Reply to this message]