Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Views Rss

   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: |  Discuss |   Briefcase | 13,759 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: |  Discuss |   Briefcase | 8,169 reads

SQL views

By Naseer Ahmad 2013/08/01 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,271 reads

Nested triggers 2

By Tom Thomson 2013/05/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,916 reads

Nested triggers 1

By Tom Thomson 2013/04/23 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 1,700 reads

Updating Views

By Steve Jones 2013/02/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,262 reads

Divide by zero

By Hugo Kornelis 2012/12/24 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,231 reads

VIEW - 9

By bitbucket-25253 2012/10/15 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,225 reads

View - 8

By bitbucket-25253 2012/10/08 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,406 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,230 reads

Views and changes

By Steve Jones 2012/07/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,799 reads

VIEWS 6

By bitbucket-25253 2012/04/10 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,538 reads

VIEWS 5

By bitbucket-25253 2012/04/03 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,124 reads

VIEWS 4

By bitbucket-25253 2012/03/27 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,807 reads

VIEWS 3

By bitbucket-25253 2012/03/20 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,588 reads

VIEWS 2

By bitbucket-25253 2012/03/12 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,833 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,759 reads

Curiouse View to create for SQLServer 2005

By Matthias Kroll 2010/02/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,698 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: |  Discuss |   Briefcase | 4,292 reads

Views

By Steve Jones 2008/12/12 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 4,149 reads
   Items 1 to 20 of 21    Older >>
 
Tags
triggers (2)    
advanced t-sql (1)    
encryption (1)    
stairway series (1)    
synonyms (1)    
video (1)