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

Content with tag DEFAULT Rss

   Items 1 to 5 of 5   
 

Declarative SQL: Using CHECK() & DEFAULT

SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to provide a lot of logic elsewhere. CHECK() and DEFAULT can do a lot to ensure that your data is correct  Read more...
By Additional Articles 2016/01/26 | Source: SimpleTalk | Category: check()
Rating: (not yet rated)  Rate this |   Briefcase | 3,871 reads

Random DEFAULT string for a column using CASE and NEWID

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random
Rating: |  Discuss |   Briefcase | 1,085 reads

Conversion of default objects to column defaults

This script can convert the usage of bound default objects in tables to column defaults  Read more...
Rating: |  Discuss |   Briefcase | 380 reads

Conversion Fun

By The Kid 2009/03/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 6,312 reads

Random DEFAULT string for a column using CASE and NEWID

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random
Rating: |  Discuss |   Briefcase | 1,085 reads
   Items 1 to 5 of 5   
 
Tags
administration (1)    
case (1)    
check() (1)    
constraints (1)    
conversion (1)    
migration (1)    
newid() (1)    
rand() (1)    
random (1)    
sp_bindefault (1)    
sp_unbindefault (1)    
t-sql (1)