|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
27/10/2006, 08h35
|
#1 |
Messages: n/a
Hébergeur: |
nvarchar default length
When creating new table fields the default size (length) of nvarchar
is set to 50. Using Management Studio, where do I change this, so that it suggests another default than 50 ? Regards /Snedker |
|
|
27/10/2006, 14h10
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: nvarchar default length
I don't believe you can.
-- Andrew J. Kelly SQL MVP "Morten Snedker" <morten_spammenot_ATdbconsult.dk> wrote in message news:k9d3k297c6vo9orfup86r3uolgok7lpu8v@4ax.com... > When creating new table fields the default size (length) of nvarchar > is set to 50. Using Management Studio, where do I change this, so that > it suggests another default than 50 ? > > > Regards /Snedker |
|
|
|
27/10/2006, 16h28
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: nvarchar default length
Hi /Snedker
This is not something you should rely on the default for. Every character column should be evaluated to determine its ideal length (or maximum length). If the default is something you don't like, that is good, because it will then require you to consider the best value for every column. -- HTH Kalen Delaney, SQL Server MVP http://sqlblog.com "Morten Snedker" <morten_spammenot_ATdbconsult.dk> wrote in message news:k9d3k297c6vo9orfup86r3uolgok7lpu8v@4ax.com... > When creating new table fields the default size (length) of nvarchar > is set to 50. Using Management Studio, where do I change this, so that > it suggests another default than 50 ? > > > Regards /Snedker |
|
|
|
| Outils de la discussion | |
|
|
