Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Content with tag DEFAULT Rss

   Items 1 to 4 of 4   
 

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,068 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...
By Michael Søndergaard 2010/01/29 | Source: SQLServerCentral.com | Category: sp_unbindefault
Rating: |  Discuss |   Briefcase | 356 reads

Conversion Fun

Read more...
By The Kid 2009/03/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 6,273 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,068 reads
   Items 1 to 4 of 4   
 
Tags
administration (1)    
case (1)    
conversion (1)    
migration (1)    
newid() (1)    
rand() (1)    
random (1)    
sp_bindefault (1)    
sp_unbindefault (1)    
t-sql (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.