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 | 1,908 reads

Nested triggers 2

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

Rating: (not yet rated) |

Discuss |

Briefcase | 1,467 reads

Nested triggers 1

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

Rating: (not yet rated) |

Discuss |

Briefcase | 1,462 reads

Updating Views

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

Rating: (not yet rated) |

Discuss |

Briefcase | 2,112 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,173 reads

Divide by zero

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

Rating: (not yet rated) |

Discuss |

Briefcase | 2,068 reads

VIEW - 9

By bitbucket 2012/10/15 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,131 reads

View - 8

By bitbucket 2012/10/08 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 2,303 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,587 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,737 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,353 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