none
What's the difference between Insert Data from a View and Table RRS feed

  • Question

  • I created a table A. Then created a View as follows:

    Create View VIEW_A AS

    SELECT * FROM A

    GO

    Here I want to use a Store Procedure to Insert Data to the table. Are there any difference between

    INSERT INTO VIEW_A XXX

    and

    INSERT INTO A

    especially INSERT large amount Data. Before I use INSERT INTO VIEW_A it works fine. But when I changed it to INSERT INTO A, I often met deadlock issue.

    Any ideas about my quesion? Thanks.


    • Edited by 络绎 Tuesday, October 23, 2012 5:19 AM Modify some typo
    Tuesday, October 23, 2012 5:17 AM

Answers

All replies