SQLServerCentral: Content tagged T-SQL, Views

Updating a View with CHECK

By Steve Jones 2016/09/15 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,070 reads

Where's the error?

By Steve Jones 2016/08/31 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,382 reads

Updating the View or the table?

By Steve Jones 2016/08/05 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,317 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios. Read more...

By Gregory Larsen 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series

Rating:

|

Discuss |

Briefcase | 11,523 reads

The View Insert

By Steve Jones 2016/07/14 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 1,347 reads

Summed Views

By Steve Jones 2016/06/27 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 1,288 reads

The altered view

By Steve Jones 2016/06/09 | Category: views

Rating: (not yet rated) |

Discuss |

Briefcase | 1,374 reads

Views

By Shiva N 2015/07/08 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,920 reads

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer. Read more...

By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: SQLServerCentral.com | Category: views

Rating:

|

Discuss |

Briefcase | 13,819 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios. Read more...

By Gregory Larsen 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series

Rating:

|

Discuss |

Briefcase | 11,523 reads