SQL - 如何更改现有视图上的排序规则
答
事情是这样的:
Alter View YourViewName
AS
Select Yourcolumn Whatever_collation_you_need
from YourTable
另外,如果你需要你的观点与另一个表或视图链接,您可以只指定这样的整理,而无需改变你的观点:
select
*
from v_Filiales f --> this is a view
inner join t_Persona p --> this is a table
on p.cPerCodigo = f.cPerJuridica COLLATE Latin1_General_CI_AS
'SELECT COL1,COL2,COL3 COLLATE The_Name_Of_The_Collation_You_Want为COL3,COL4 ....' – Lamak
你的意思是这样的: – Coloplast
ALTER VIEW [DBO] [PS_CP_TRACKUSER_VW] AS SELECT NAME COLLATE Latin1_Genera l_BIN作为名称 – Coloplast