Sql Seveur : problème de collation sur des tables temporaires

Sql serveur  | Blog.bullrox.netAvez vous déjà peut-être rencontré ce genre d’erreur :

Msg 468, Level 16, State 9, Line 2
Cannot resolve the collation conflict between “Latin1_General …” and “Latin1_General …”

La solution est simple mais peu commune :

SELECT cast(null as varchar(40)) as Colonne1
INTO #tabletemp
INSERT INTO #tabletemp
SELECT colonne FROM table

To be continued …

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *