Quite often I get request if I send blog post in newsletter or through email. Here are few important links. You can subscribe to blog posts by email or feed, or follow me on Twitter.
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
Follow me on Twitter
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.
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