TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Debasis Mohapatra
NA
381
57.2k
Windows based program getting error from sql server
Apr 23 2019 6:38 AM
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Reply
Answers (
3
)
2
Debasis Mohapatra
0
381
57.2k
Apr 25 2019 3:32 AM
I got the solution.
select *,l.name as Divname from DB_PL_SETUP.dbo.tbl_profile p inner join tbl_Location l on p.location collate SQL_Latin1_General_CP1_CI_AS =l.loccd where p.uid='admin'
0
Mohsin Arif
307
6k
138.6k
Apr 25 2019 3:43 AM
its good
0
Mohsin Arif
307
6k
138.6k
Apr 23 2019 6:43 AM
hi
please read this articale
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/01671529-337a-474b-89d3-dc1fb21d641f/how-to-fix-an-errorquotcannot-resolve-the-collation-conflict-between?forum=transactsql
WCF Restfull Service or Web API Token
Calling two functions on a onChange event