Click here to Skip to main content
15,881,568 members
Home / Discussions / Database
   

Database

 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 5:29
professionalGuyThiebaut30-Mar-13 5:29 
GeneralRe: Views vs Tables Pin
PIEBALDconsult30-Mar-13 5:51
mvePIEBALDconsult30-Mar-13 5:51 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 5:57
professionalGuyThiebaut30-Mar-13 5:57 
GeneralRe: Views vs Tables Pin
jschell30-Mar-13 12:46
jschell30-Mar-13 12:46 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 20:37
professionalGuyThiebaut30-Mar-13 20:37 
GeneralRe: Views vs Tables Pin
jschell31-Mar-13 11:31
jschell31-Mar-13 11:31 
GeneralRe: Views vs Tables Pin
jschell30-Mar-13 12:45
jschell30-Mar-13 12:45 
AnswerRe: Views vs Tables Pin
Corporal Agarn29-Mar-13 7:43
professionalCorporal Agarn29-Mar-13 7:43 
Since a view can become out of sync with the underlying table, it is not a good idea to insert through a view, [sarcasm]unless you are using MS Access[/sarcasm].

Another problem is, if there are multiple tables in the view things go wrong quickly.

Now if he would have said you should use a stored procedure to do the insert then I would say he has a point. However it is not wrong to insert directly into a table.
AnswerRe: Views vs Tables Pin
jschell29-Mar-13 11:00
jschell29-Mar-13 11:00 
GeneralRe: Views vs Tables Pin
PIEBALDconsult29-Mar-13 15:38
mvePIEBALDconsult29-Mar-13 15:38 
AnswerRe: Views vs Tables Pin
Mycroft Holmes29-Mar-13 13:19
professionalMycroft Holmes29-Mar-13 13:19 
GeneralRe: Views vs Tables Pin
PIEBALDconsult29-Mar-13 15:43
mvePIEBALDconsult29-Mar-13 15:43 
GeneralRe: Views vs Tables Pin
Mycroft Holmes29-Mar-13 17:13
professionalMycroft Holmes29-Mar-13 17:13 
GeneralRe: Views vs Tables Pin
Jörgen Andersson30-Mar-13 8:55
professionalJörgen Andersson30-Mar-13 8:55 
GeneralRe: Views vs Tables Pin
jschell30-Mar-13 12:48
jschell30-Mar-13 12:48 
GeneralRe: Views vs Tables Pin
Jörgen Andersson30-Mar-13 22:43
professionalJörgen Andersson30-Mar-13 22:43 
GeneralRe: Views vs Tables Pin
jschell31-Mar-13 11:42
jschell31-Mar-13 11:42 
GeneralRe: Views vs Tables Pin
Mycroft Holmes30-Mar-13 13:11
professionalMycroft Holmes30-Mar-13 13:11 
GeneralRe: Views vs Tables Pin
Jörgen Andersson30-Mar-13 22:45
professionalJörgen Andersson30-Mar-13 22:45 
GeneralRe: Views vs Tables Pin
Mycroft Holmes30-Mar-13 23:10
professionalMycroft Holmes30-Mar-13 23:10 
GeneralRe: Views vs Tables Pin
Jörgen Andersson31-Mar-13 0:15
professionalJörgen Andersson31-Mar-13 0:15 
QuestionSSRS: Justify TextBoxes Pin
Anderson Beppler28-Mar-13 7:52
Anderson Beppler28-Mar-13 7:52 
AnswerRe: SSRS: Justify TextBoxes Pin
thatraja4-Oct-13 20:36
professionalthatraja4-Oct-13 20:36 
QuestionMoving File Groups and Tables in SQL Server Pin
Ennis Ray Lynch, Jr.27-Mar-13 10:38
Ennis Ray Lynch, Jr.27-Mar-13 10:38 
AnswerRe: Moving File Groups and Tables in SQL Server Pin
Eddy Vluggen27-Mar-13 11:40
professionalEddy Vluggen27-Mar-13 11:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.