|
Registriert seit: 3. Mai 2003
140 Beiträge
Delphi 2006 Enterprise
|
Re: [MSSQL2000] datetime / smalldatetime unterscheiden
23. Apr 2007, 22:30
also bisher habe ich sowas noch nie benötigt - eine Möglichkeit wäre jedoch das DataDictionary abzufragen:
SQL-Code:
select DATA_TYPE
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'TABELLE' and COLUMN_NAME = 'SPALTE'
mr2
"... we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we don't know. But there are also unknown unknowns - the ones we don't know we don't know."
|