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

Content with tag CHECK constraints Rss

   Items 1 to 11 of 11   
 

The Case for Scalar-valued, User-defined Functions in T-SQL

Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...  Read more...
By Dwain Camps 2015/05/12 | Source: SQLServerCentral.com | Category: scalar udf
Rating: |  Discuss |   Briefcase | 5,952 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,635 reads

Introduction to SQL Server Check Constraints

Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.   Read more...
Rating:  Rate this |   Briefcase | 4,856 reads

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 6,951 reads

Re-Trust Untrusted Foreign Keys and Constraints

This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.  Read more...
By Shaun J. Stuart 2013/06/17 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 720 reads

Query Tuning

By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,089 reads

A Developers' Guide to Refactoring Databases

When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile methodologies for application development? Nick suggests that the technical solutions already exist, and the dissonance is more due to cultural and organizational problems  Read more...
By Additional Articles 2011/05/04 | Source: SimpleTalk | Category: check constraints
Rating:  Rate this |   Briefcase | 5,573 reads

Check your Digits

The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.  Read more...
By Additional Articles 2011/04/28 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,014 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,268 reads

Fix Column Check Constraint Naming

This stored procedure can be used for applying a custom column check constraint naming convention  Read more...
By Michael S√łndergaard 2010/10/12 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 516 reads

Using Check Constraints to Validate Data in SQL Server

A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.  Read more...
By Additional Articles 2009/04/10 | Source: Database Journal | Category: check constraints
Rating:  Rate this |   Briefcase | 2,217 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (4)    
indexing (2)    
table (2)    
change constraint name (1)    
computed columns (1)    
constraints (1)    
create (1)    
database design (1)    
default constraints (1)    
execute (1)    
foreign keys (1)    
foreign keys (fk) (1)    
implicit conversions (1)    
naming convention (1)    
null (1)    
primary key (pk) (1)    
read only (1)    
sargability (1)    
scalar udf (1)    
trigger (1)    
unique (1)    
xml (1)