Cannot resolve collation conflict for column 2 in SELECT statement

In MS SQL SERVER, the collation can be set in column level. When compared 2 different collation column in the query, this error comes up. Following article gives you details on fixing the collation problems.

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

In addition select statement can also be a cause for the above problem

E.g.
SELECT  P.ID,P.PASSENGER_NAME  +' '+ISNULL(P.LAST_NAME,'')  [PASSENGER_NAME],P.BAG_COUNT 
    FROM am.PASSENGER P

In the above table both PASSENGER_NAME and LAST_NAME columns has datatype of nvarchar(50). When I ran the above query the collation conflict error occured and following way I was able to fix it.


SELECT  P.ID,
P.PASSENGER_NAME  +' '+ISNULL(P.LAST_NAME,'')  COLLATE DATABASE_DEFAULT [PASSENGER_NAME],
P.BAG_COUNT 
    FROM am.PASSENGER P

cheers
Happy coding
samitha (MCTS)

SharePoint 2010 For Developers

English | WMV3 1024 x768 | MP3 48 Kbps | 363 MB
Genre: eLearning

Over the past several months, we’ve shared several introductory features about new assets for developers in SharePoint 2010. As Microsoft launches Office 2010 and SharePoint 2010 to businesses this week, we now bring you a real-world example of how developers can harness and capitalize upon the enhancements of the new version.

Download
http://hotfile.com/dl/47466839/714426c/SP2010FD.part1.rar.html
http://hotfile.com/dl/47466843/1607fc5/SP2010FD.part2.rar.html
http://hotfile.com/dl/47466841/e173e92/SP2010FD.part3.rar.html
http://hotfile.com/dl/47466842/28fe075/SP2010FD.part4.rar.html


cheers,
Happy coding,
Samitha

Writing a Debugger Visualizer in WPF

A good one to start with. Have a look

http://www.codeguru.com/csharp/.net/net_debugging/article.php/c17429

cheers
happy coding
samitha

Preventing Users From Copying Text From and Pasting It Into TextBoxes

Many websites that support user accounts require users to enter an email address as part of the registration process. This email address is then used as the primary communication channel with the user. For instance, if the user forgets her password a new one can be generated and emailed to the address on file. But what if, when registering, a user enters an incorrect email address? Perhaps the user meant to enter me@example.com, but accidentally transposed the first two letters, entering em@example.com. How can such typos be prevented?

Read more at http://www.4guysfromrolla.com/articles/060910-1.aspx

Cheers,
Samitha

New Features in Windows Communication Foundation (WCF) 4.0

Take a look at the new features and an introduction to WCF 4.0 framework.

Read More at WCF 4.0 Features

Cheers,

Samitha

Extract SWF files from Flash Executables

Lost your SWF file but still have a projector (EXE) version kicking around? Use exe2swf to recover your original SWF so you can get at the assets it contains instead of trying to recreate your project completely from scratch.

exe2swf

Cheers
Samitha

Microsoft Robotics Developer Studio 2008 2.2.76.0

Microsoft® Robotics Developer Studio 2008 R3 enables hobbyists and professional or non-professional developers to create robotics applications targeting a wide range of scenarios. The R3 release is a minor update that has the functionality of the previous Standard Edition, but is available at no cost to all users. As of the R3 release there are no separate Editions and only a single download.

Download

Cheers
Samitha