How to Add Facebook Fan Page Widget In Blogger

Facebook is the biggest way to promote your blog because almost everyone uses facebook. Many ways to promote your blog on facebook and facebook fan page is one of them. You can create facebook fan page for your blog or website and increase like for your fan page.
You can easily add your fan page like box widget on your blogger blog. In this post we will discuss  about How to Add Facebook like Box Widget for Blogger. 

Add Facebook Fan Page Widget

Here are the step to Add Facebook Fan Page Widget :

1. Log in into Blogger Dashboard and Go to Layout then click on Add a Gadget link.
2. Add HTML/JavaScript
3. Insert below code into box

   [iframe allowtransparency="true" frameborder="0" scrolling="no" src="//www.facebook.com/plugins/likebox.php?href=http%3A%2F%2Fwww.facebook.com%2
   FIlkomerss&width=240&
   height=190&show_faces=true&
   amp;stream=false&header=false&show_border=false" style="border: none; height: 200px; overflow: hidden; width: 250px;"][/iframe]
   

   
   
4.  Change Ilkomerss to your facebook page name. You can also change Width and Height as your requirement.
5. Click on save button.

How to resolve error Msg 468 : Cannot resolve collation conflict in SQL Server

If you've ever worked with SQL Server you've probably encountered an error like this: 

Msg 468, Level 16, State 9, Line 1
Cannot resolve collation conflict between 'Latin1_General_CI_AS' and 'SQL_Latin1_General_CP1_CI_AS' in equal to operation.

This error is cause by having different collation settings for the columns in the comparison. SQL Server cannot reliably resolve how the columns should be compared to determine if they meet your conditions. For example, when you compare two columns that are both case-sensitive (Latin1_General_CS_AS) then 'AA' = 'AA', but 'Aa' != 'AA'. On a case-insensitive collation 'Aa' = 'AA'.
Where code pages change, or the case or accent sensitivity changes, SQL Server may require you to specify which collation is to be used during comparison.

In this case the error was caused by a comparison of two columns in a join clause where the source tables were from databases with different collations.
Resolving the error is as simple as adding the COLLATE codepage keyword after the column. You can figure out which is the offending column and change its collation, or change both columns to the same collation.

-- Example COLLATE Fix for a JOIN condition
SELECT
   TableA.col1,
   TableB.col2
FROM TableA
INNER JOIN TableB
ON TableA.col3  COLLATE Latin1_General_CI_AS = TableB.col3 COLLATE Latin1_General_CI_AS

-- Example COLLATE Fix for a WHERE condition
SELECT
   TableA.col1
FROM DatabaseA.dbo.TableA, dbo.TableB
WHERE TableA.col3 COLLATE Latin1_General_CI_AS = Max(TableB.col2)


-- Example COLLATE Fix for a WHERE IN condition
SELECT
   TableA.col1
FROM TableA
WHERE TableA.col3 COLLATE Latin1_General_CI_AS IN (SELECT TableB.col1 FROM TableB)

You can check the collation setting for a column using the sp_help TableName command.

How to add code block in blogger

It is good to have a code area in your blogger posts if you want to write down code, blogger widgets, blogger templates or it deals with any kind of blog customization. It will become easy for anybody to locate the html code and easily copy and paste the code for using it. It will also give a well organised look to your blog posts.
To add code block in blogger, read and follow the steps below :

1. Log in to your blogger account. Go to Dashboard >> Template.


2. Click on the Customize.


3. GO to Advanced >> Add CSS.


4. Copy and Paste the following code in the Add CSS section.

   .code {
       background: #f5f8fa;
       background-repeat: no-repeat;
       border: solid #5C7B90;
       border-width: 1px 1px 1px 20px;
       color: #000000;
       font: 13px 'Courier New', Courier, monospace;
       line-height: 16px;
       margin: 10px 0 10px 10px;
       max-height: 200px;
       min-height: 16px;
       overflow: auto;
       padding: 28px 10px 10px;
       width: 90%;
   }
   
   .code:hover {
       background-repeat: no-repeat;
   }

5. Now when you are composing new post, select HTML section and paste the following code.

   your code here

6. Continue your writing and publish