Blog Timeline

SQL Server 2008 Resolve the collation conflict!

  • Friday, March 16, 2012
  • by hbopuri

usually when we write a joining query we get this Collation problem. and to fix it, run this query for both the columns being compared ALTER TABLE [TableName] ALTER COLUMN [ColumnName]             DataType(11)COLLATE Latin1_General_CI_AS NOT NULL

Adding Primary key to view SQL Server 2008

  • Thursday, March 15, 2012
  • by hbopuri

SELECT isnull(server.[dbo].[table].[ProductId],-1) AS ProductID This will create the Primarykey to the view. why do you need primary key? one of the reason is, view with no primary key from any fields selected will not be added to Entity Model.

Search

Latest Posts

  • Fix: Error with loading AuthorizeNet payment plugin during debug - NopCommerce

    Read more
  • Rebind Data to Telrik MVC grid with difference or new Parameters

    Read more
  • SQL Server 2008 Resolve the collation conflict!

    Read more