SQLServerCentral: Content tagged Views

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects. Read more...

By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures

Rating:

|

Discuss |

Briefcase | 2,541 reads

Nested triggers 2

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

Rating: (not yet rated) |

Discuss |

Briefcase | 1,670 reads

Nested triggers 1

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

Rating: (not yet rated) |

Discuss |

Briefcase | 1,521 reads

Updating Views

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

Rating: (not yet rated) |

Discuss |

Briefcase | 2,124 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,232 reads

Divide by zero

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

Rating: (not yet rated) |

Discuss |

Briefcase | 2,092 reads

VIEW - 9

By bitbucket 2012/10/15 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,139 reads

View - 8

By bitbucket 2012/10/08 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,311 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,593 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,183 reads

Views and changes

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

Rating: (not yet rated) |

Discuss |

Briefcase | 2,739 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,369 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,086 reads