Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2005-12-27 : 15:10:10
|
| We have a table that needs to have 00 as the default values in the columns until the point in time where they are updated with the values that we will use. The updated values will be two numbers 1-7 and 3-9 example 47, 14, 26, 68. This is a nvarchar data type in the columns. When I try to set the default values to double zero 00, after i click save it changes them to a single zero 0 instead of a double zero 00.Miranda |
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-27 : 15:19:04
|
| i hope i have it figured out, i have enclosed the double zeros 00 in single quotes '00'Miranda |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2005-12-27 : 15:56:44
|
| Is the datatype of your column character or numeric? |
|
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-27 : 16:02:52
|
| data type is nvarcharMiranda |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2005-12-27 : 16:52:15
|
| Then enclosing your value in single quotes should do the trick. |
|
|
|
|
|
|
default values