SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, CHECK constraints Rss

   Items 1 to 6 of 6   

CHECKING specific values

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

CHECKing Values

By Steve Jones 2016/01/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,586 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: SQLServerCentral.com | Category: scalar udf
Rating: |  Discuss |   Briefcase | 6,252 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,770 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,256 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,299 reads
   Items 1 to 6 of 6   
computed columns (1)    
create (1)    
default constraints (1)    
execute (1)    
foreign keys (fk) (1)    
indexing (1)    
null (1)    
primary key (pk) (1)    
scalar udf (1)    
table (1)    
unique (1)    
xml (1)