How to search a column name within all tables of a database?

Here is how we can get table name and column which you are looking for,

SELECT table_name,column_name FROM information_schema.columns
WHERE column_name like '%engine%'
-- OR ---
SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%engine%'

Sample OUTPUT for one of the query,

ColName    TableName
EngineType    DSS_Setup

CRICPICKS : APPS

For those who are not aware of Cricpicks Apps we are now available on both App Store and Google Play.

Please note that you can download CRICPICKS mobile applications from Google Play and we are coming soon on Mac App Store for iTunes! 

Have fun playing CRICPICKS and good luck winning prizes!

How do I clear the Facebook Share's Cache?

Sometimes you have a new description, title or thumbnail image in your website. But when you share the website URL on Facebook, it may still using the old description/ title/ image that no longer exists.

In order to clearing the Facebook sharer cache, there are few different ways like using tinyurls or modifying the URL by adding query strings. Since Facebook considers each one as different URL this might be quick way to do it.

The best and preferred way is to use Facebook Debugger tool which is formerly known as URL Linter to clear fb cache of your website. Go to below link and Type your website's or article's URL there and click debug button..

http://developers.facebook.com/tools/debug

After doing this, re-share your website's link on Facebook. You can find that Facebook sharer displaying your latest content.

Hope this helps!!

CRICPICKS–IPL PICK’EM GAMES

We friends have developed IPL Pick’em Game site for Cricket. You might have seen Fantasy games and other Pick’em games in football and others sports. We have brought Pick’em contest to CRICKET!. Yes that’s REAL. We took IPL to next level.

CRICPICKS is a great site to play PICKS competition and win may prizes. It is a very simple game, all you need is a valid email address and pick who will win a match of the tournaments. The site provide help to do your pick. You too can join the CRIPICKS competition for FREE to play and WIN many prizes. For more details go to CRICPICKS

Features:

1. Play against all registered users
2. Create your own groups and play with the same group at the same time. You can create your own group and work and apartments etc. and have fun by leading your groups.
3. Groups created by you can be managed by multiple users by making them as Moderators of your group.
4. You can set reminders of your favorite teams matches. So need to worry that you will miss action. We take care of this for you by sending match reminders.
5. And more over its absolutely free and you can get weekly prizes up to $ 100 or Rs 6000.00/- in cash and also you will be eligible of for Grand prize of winning a tablet this season.

Please note that you can download CRICPICKS mobile applications from Google Play and we are coming soon on Mac App Store for iTunes! 

Have fun playing CRICPICKS and good luck winning prizes!

Remove the AnchorTag Border

I have a AJAX Tab container and in that on selection its giving me a border on the Header Text of the Tab. To remove this using CSS, here is how we can do it

.ajax__tab_inner a.ajax__tab_tab{width:100%;border:0 !important;outline: none; }

a:focus { 
        outline: none; 
    }

This is what will fix the issue. Hope this helps!