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,832 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,601 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,855 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,948 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 | 696 reads

Query Tuning

By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,085 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,569 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,009 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,264 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 | 511 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,207 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)