SQL Server empty string default values

J

Justin

Hi, I have created a DB model in Visio and have generated
the DB in SQL Server. I need to create default values of
empty strings for varchar columns. Normally in SQL
Server this is done by two single quotes but when you
enter these as the default value for a column, Visio then
sets the SQL Server column default to a single quote
rather than an empty string. I have tried a single
quote, two single quotes and two double quotes. None of
these give me an empty string default value in SQL Server.
Any ideas?
Thanks
PS: using Visio for Enterprise Architects v10.0.2795 and
SQL Server 2000 SP3a.
 
M

Maria

You could try reverse-engineering a test table that has the behaviour you want, and see what Visio comes up with.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
SQL Server 2005 xml DataType 0
Setting DEFAULT to empty string using SQL 2
Reverse Enginerer 2
How to use text filter in Access with SQL Server database 1
Replacing "null" with "(default") in a combobox 4
Visio doesn't like bigint identity columns - is it just me? 0
sql db default value in access 1

Top