Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Views Rss

   Items 1 to 20 of 29    Older >>
 

Updating a View with CHECK

By Steve Jones 2016/09/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,022 reads

Where's the error?

By Steve Jones 2016/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,356 reads

Updating the View or the table?

By Steve Jones 2016/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,310 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,515 reads

The View Insert

By Steve Jones 2016/07/14 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,345 reads

Summed Views

By Steve Jones 2016/06/27 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,286 reads

The altered view

By Steve Jones 2016/06/09 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,373 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,515 reads

SQL views

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

Nested triggers 2

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

Nested triggers 1

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

Updating Views

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

Divide by zero

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

VIEW - 9

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

View - 8

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

Views and changes

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

VIEWS 6

By bitbucket-25253 2012/04/10 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,580 reads
   Items 1 to 20 of 29    Older >>
 
Tags
triggers (2)    
advanced t-sql (1)    
encryption (1)    
stairway series (1)    
synonyms (1)    
update (1)    
video (1)    
with check option (1)