SQLServerCentral: Content tagged T-SQL, Views

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Write for us

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tags T-SQL, Views

Items 1 to 20 of 21 Older >>

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:

|

Briefcase | 10,997 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 2014/03/19 | Source: SQLServerCentral.com | Category: stairway series

Rating:

|

Briefcase | 6,640 reads

SQL views

By Naseer Ahmad 2013/08/01 | Category: views

Rating: (not yet rated) |

Briefcase | 2,208 reads

Nested triggers 2

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

Rating: (not yet rated) |

Briefcase | 1,875 reads

Nested triggers 1

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

Rating: (not yet rated) |

Briefcase | 1,673 reads

Updating Views

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

Rating: (not yet rated) |

Briefcase | 2,235 reads

Divide by zero

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

Rating: (not yet rated) |

Briefcase | 2,201 reads

VIEW - 9

By bitbucket-25253 2012/10/15 | Category: views

Rating: (not yet rated) |

Briefcase | 2,196 reads

View - 8

By bitbucket-25253 2012/10/08 | Category: views

Rating: (not yet rated) |

Briefcase | 2,380 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:

|

Briefcase | 5,216 reads

Views and changes

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

Rating: (not yet rated) |

Briefcase | 2,779 reads

VIEWS 6

By bitbucket-25253 2012/04/10 | Category: views

Rating: (not yet rated) |

Briefcase | 2,520 reads

VIEWS 5

By bitbucket-25253 2012/04/03 | Category: views

Rating: (not yet rated) |

Briefcase | 2,107 reads

VIEWS 4

By bitbucket-25253 2012/03/27 | Category: views

Rating: (not yet rated) |

Briefcase | 2,792 reads

VIEWS 3

By bitbucket-25253 2012/03/20 | Category: views

Rating: (not yet rated) |

Briefcase | 2,569 reads

VIEWS 2

By bitbucket-25253 2012/03/12 | Category: views

Rating: (not yet rated) |

Briefcase | 2,815 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:

|

Briefcase | 10,997 reads

Curiouse View to create for SQLServer 2005

By Matthias Kroll 2010/02/10 | Category: t-sql

Rating: (not yet rated) |

Briefcase | 3,688 reads

Using Views and Synonyms for Abstraction - SQL School Video

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms. Read more...

By Brian Knight 2009/01/22 | Source: JumpStartTV | Category: video

Rating:

|

Briefcase | 4,244 reads

Views

By Steve Jones 2008/12/12 | Category: views

Rating: (not yet rated) |

Briefcase | 4,137 reads

Items 1 to 20 of 21 Older >>