22 September 2009
21:14:23
sergey
Posts: 0
|
T-SQL Check Column type
declare @type varchar(64) SELECT @type= DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DRIVERS' and COLUMN_NAME ='DR_USER'
IF @type ='varchar'
print 'We are here!'
|
22 September 2009
21:15:10
sergey
Posts: 0
|
Re: T-SQL Check Column type
weblogs.sqlteam.com/joew/archive/2008/04/27/60574.aspxSELECT ORDINAL_POSITION ,COLUMN_NAME ,DATA_TYPE ,CHARACTER_MAXIMUM_LENGTH ,IS_NULLABLE ,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Product' ORDER BY ORDINAL_POSITION ASC;
|
22 September 2009
21:15:30
sergey
Posts: 0
|
Re: T-SQL Check Column type
select * from syscolumns
where id=object_id('Customers')
ORDER BY
colid ASC
|