Wednesday, May 9, 2007

Find specific data type of the column

Recently i was told to return tables which have FLOAT datatype defined on columns.The version of the product was SQL Server 2000 ,however it will work on SQL Server 2005 as well, so take a look at very very simple script.

SELECT columns.TABLE_NAME ,COLUMN_NAME
FROM information_schema.columns columns
JOIN information_schema.tables tables
ON tables.table_name = columns.table_name
WHERE tables.table_type = 'base table'
AND columns.data_type = 'float'
ORDER BY columns.table_name, columns.column_name

4 comments:

xiaoqiu said...

These 2 spells will make you pretty much rohan crone invincible with nearly no need for potting. For your PVP you are gonna need to rely on your ability to maximize your Rapid Lock spell and be able to use your rohan gold to Health to mana spell efficiently. They problem for a typical Dekan Sage build is to not supply the rohan online crone needed to sustain these spells. Mana guard is where this build is going to shine and make you pretty much rohan money invincible for 60 seconds which is more than enough time to dispatch most classes in PVP. Rohan is cool so far, much easier than most free games without any rohan online gold that starts spazzes on you.

Replica Watches said...

29047126483369175 I play dofus Replica Watches for one year, I Replica Rolex Watches want to get some Replica Watch kamas to buy Replica Chanel Watches item for my character. So, I search "Replica Swiss Watches" on google and found many website. As Exact Replica Graham Watch the tips from the forum, I just review the Swiss Replica Watches websites and choose some Replica Montblanc Watches quality sites to Replica Cartier Watches compare the price, and go to their Replica Breguet Watches online support to make Replica Breitling Watches the test. And Last Chaos Gold I decide to use Replica BRM Watch at the end. And Tag Heuer Replica Watch that is the Replica IWC Watch beginning..

aiya said...
This comment has been removed by a blog administrator.
josez davis said...

These people were the dream about a sole gentleman, the exact son of this watch supplier, whose adoration thus to their pop's art been for a while being hardcore inside 1875. Soon after greater millennium involving one of a kind design, most of these special wristwatches always promote enthusiasm replica Rado into the knowledgeable aficionados whom put them on. There's cheap replica Fendi handbags some sort of movement outset, accurate in replica chanel handbags conjunction with genuine, that can honors this delicate interior operation regarding Armand Nicolet wristwatches. Accurate enthusiasts are typically attracted on their own originality and as well technological know-how Cheap Replica Audemars Piguet Watches UK due to the fact affecting Armand Nicolet's 1902 account enjoy. Which has a "guilloche" rose platinum circumstances, one solution chronographic accomplish, comprehensive time-table, duplicating a while, one fourth a while along having min's, it was eventually a masterpiece into their day time period which exhibited the exact maturity about Armand's power cheap fake Richard Mille watches and set needed for many Armand Nicolet wristwatches to are available.