Solved

Changing collation of existing view

Posted on 2008-06-25
3
1,379 Views
Last Modified: 2008-06-26
Hi folks,
Is it possible to change the collation propert of an existing view? If yes, could you please describe how.
0
Comment
Question by:innocent1973
  • 2
3 Comments
 
LVL 12

Expert Comment

by:patrikt
ID: 21864538
What is Collation of View? Do you mean collation of some column in result or order collation?
For changing collation you can use '<column> COLLATE <collation name> '. It will convert column output to desired collation.

Patrik
0
 

Author Comment

by:innocent1973
ID: 21864794
is it possible to convert all columns in once?
0
 
LVL 12

Accepted Solution

by:
patrikt earned 500 total points
ID: 21864914
No, COLLATE  is like a function so acts only on preceding expression.
But why do you need to convert all? Your table is wrong or other problem? May be there is simplier solution.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Physical server SQL Server swap file size and memory allocation ? 4 78
Analysis of table use 7 43
Help with SQL - TOP 10 by date and by group 13 34
Sql query 107 29
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now