博 之 文

摘要：ALTER VIEW [dbo].[V_MyFriendsZhiNengShow] AS select * from( select myf.*,cast(Pro.firstName as nvarchar(30))+ cast(Pro.LastName as nvarchar(20))+' : '+cast(snsUser.email as nvarchar(50)) as name,Pro.LastName,Pro.firstName,snsUser.email, case (select PATINDEX('[a-z]' COLLATE Chinese_P 阅读全文