I posted a blog post about Collation Conflict some time back. With the discussions on Temp tables and table variables are on let us do this with a table variables.
Let us prepare the data set needed.
Then run the following using a table variable instead of temp table.
and this it is a success ( With using temp table, this will fail since tempDB in different collation)
So another place to use table variable and the debut continues …
No comments:
Post a Comment