Quite often I get request if I send blog post in newsletter or through email. Here are few important links.
You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog.
Subscribe to blog post through email
Search SQLAuthority – This is very powerful search. Give it a try.
Follow me on Twitter
Reference: Pinal Dave (https://blog.sqlauthority.com)
3 Comments. Leave new
Please subscribe me for the daily newsletter.
Thank & Best Regards,
Sandeep
select * from dbo.TempCh where [customer name] like ‘上海精元机械有限公司’ collate Chinese_PRC_CI_AI_KS_WS
Default Collation:SQL_Latin1_General_CP1_CI_AS
[customer name] Column collation :Chinese_PRC_CI_AI_KS_WS
I have record in TempCh with ‘上海精元机械有限公司’ customer name.
but in my above query i do not get row.
What to do ? Any one has idea?
Thanks
Darshan Shah
What happens when you try this?
select * from dbo.TempCh where [customer name] like N‘上海精元机械有限公司’ collate Chinese_PRC_CI_AI_KS_WS