Subject | Detect all currency field in a database |
---|---|
Author | svanderclock |
Post date | 2009-09-22T14:37:18Z |
Hello,
I want to know if it's possible to detect all currency field in a database? for now i use this "trick": only currency field are Numeric(15,5) but i just want to know if their is no better way to put a "flag" or a comment on a field to indicate that it's store currency ?
Also how to make a storedprocedure that will update in a database ALL field that are Numeric(15,5) ?
thank you by advance
stephane
--
http://www.arkadia.com/fra/immobilier/vente/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/
http://www.arkadia.com/usa/real-estate/for-sale/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/
http://www.arkadia.com/rus/real-estate/for-sale/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/
I want to know if it's possible to detect all currency field in a database? for now i use this "trick": only currency field are Numeric(15,5) but i just want to know if their is no better way to put a "flag" or a comment on a field to indicate that it's store currency ?
Also how to make a storedprocedure that will update in a database ALL field that are Numeric(15,5) ?
thank you by advance
stephane
--
http://www.arkadia.com/fra/immobilier/vente/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/
http://www.arkadia.com/usa/real-estate/for-sale/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/
http://www.arkadia.com/rus/real-estate/for-sale/france/provence-alpes-cote-d-azur/alpes-maritimes/cannes/