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

Content with tag Database objects Rss

   Items 1 to 2 of 2   

Painless Refactoring of SQL Server Database Objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.  Read more...
By Additional Articles 2015/04/08 | Source: SimpleTalk | Category: database objects
Rating:  Rate this |   Briefcase | 10,785 reads

Incorporating XML into your Database Objects

XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.  Read more...
By Additional Articles 2012/01/20 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,386 reads
   Items 1 to 2 of 2   
xml (1)