Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Changing collation of existing view

Posted on 2008-06-25
3
Medium Priority
?
1,385 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 2000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Integration Management Part 2
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

971 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