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

  • SQL Server 2008 Resolve the collation conflict!

    Read more
  • Adding Primary key to view SQL Server 2008

    Read more
  • How to Format Telephone Numbers in Telerik MVC Grid

    Read more