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

Content with tag CHECK constraints Rss

   Items 1 to 13 of 13   

CHECKING specific values

By Steve Jones 2016/02/23 | Category: check constraints
Rating: (not yet rated) |  Discuss |   Briefcase | 1,383 reads

CHECKing Values

By Steve Jones 2016/01/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,483 reads

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: | Category: scalar udf
Rating: |  Discuss |   Briefcase | 6,199 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,724 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,885 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: | Category: read only
Rating: |  Discuss |   Briefcase | 6,981 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: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 848 reads

Query Tuning

By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,117 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,642 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,081 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: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,282 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: | Category: constraints
Rating: |  Discuss |   Briefcase | 528 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,294 reads
   Items 1 to 13 of 13   
t-sql (6)    
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)