Default empty string

• smknox

  Hall of Fame

  Points: 3275

  More actions

  January 24, 2005 at 5:09 am

  #164291

  Greetings!

  I'd like to put a default empty string in string columns so I can make those columns "Not Null". I tried ' ' in the default line to no avail. How would I do that?

  Thanks,

  SMK

• PBirch

  SSCrazy Eights

  Points: 8493

  More actions

  January 24, 2005 at 8:55 am

  #538770

  What I do sometimes is create a User Defined Data type of SQLEmpty (or whatever naming convention is used). Define it as ' ', then use that for the defaults.

  Quand on parle du loup, on en voit la queue

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 24, 2005 at 1:00 pm

  #538807

  USE tempdb

  CREATE TABLE #t

  (

   c1 VARCHAR DEFAULT ''

  )

  INSERT INTO #t DEFAULT VALUES

  SELECT * FROM #t

  DROP TABLE #t

  works for me. However, I think you're doing this with EM. In that case, you might need to place some () around the ''.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• smknox

  Hall of Fame

  Points: 3275

  More actions

  January 24, 2005 at 1:07 pm

  #538808

  Wow thanks, Frank. That did it. It's usually the little things like that that consume great quantities of time.

  SMK