Message
De
31/08/2006 18:02:52
À
31/08/2006 17:51:42
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01150189
Message ID:
01150248
Vues:
34
>Ok, thanks.
>But it only changes the database all the columns have the original collate
>
>I need also change the columns
>But it only changes the database all the columns have the original collate
>
>I need also change the columns
ALTER TABLE YourTable ALTER COLUMN YourColumn CHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst