SQLServerCentral: Content tagged Views

Nested triggers 2

By Tom Thomson 2013/05/08 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,418 reads

Nested triggers 1

By Tom Thomson 2013/04/23 | Category: triggers

Rating: (not yet rated) |

Discuss |

Briefcase | 1,449 reads

Updating Views

By Steve Jones 2013/02/07 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,109 reads

My view isn’t reflecting changes I’ve made to the underlying tables.

Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. Over... Read more...

By Kenneth Fisher 2013/01/29 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 2,166 reads

Divide by zero

By Hugo Kornelis 2012/12/24 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,066 reads

VIEW - 9

By bitbucket 2012/10/15 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,130 reads

View - 8

By bitbucket 2012/10/08 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,301 reads

What a View

I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design. Read more...

By John Esraelo 2012/10/02 | Source: SQLServerCentral.com | Category: views

Rating:

|

Discuss |

Briefcase | 7,586 reads

Views and Dependencies

Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views Read more...

By John Reitter 2012/07/10 | Source: SQLServerCentral.com | Category: views

Rating:

|

Discuss |

Briefcase | 5,182 reads

Views and changes

By Steve Jones 2012/07/02 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,736 reads

Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable. Read more...

By Additional Articles 2012/06/21 | Source: SimpleTalk | Category: views

Rating:

Rate this |

Briefcase | 4,352 reads

SQL VIEW Basics

SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it. Read more...

By Additional Articles 2012/06/01 | Source: SimpleTalk | Category: views

Rating:

Rate this |

Briefcase | 5,074 reads