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

CHECKing Values

By Steve Jones 2016/01/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,581 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,239 reads

CHECK Constraints vs NULL values

By Justin Clementz 2015/05/01 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,766 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,194 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,294 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)