34,590
社区成员
发帖
与我相关
我的任务
分享
declare @columnName varchar(80)
DECLARE CURSOR1 CURSOR FOR
select column_name from information_schema.columns where table_name='mdthreepl'
Open CURSOR1
FETCH NEXT FROM CURSOR1 INTO @columnName
WHILE @@FETCH_Status=0
BEGIN
print @columnName
if isdate(@columnName)=1
print '是時間'
else
print '不是時間'
FETCH NEXT FROM CURSOR1 INTO @columnName
END
CLOSE CURSOR1
DEALLOCATE CURSOR1
declare @columnName varchar(80)create table tb(c1 int,c2 char(10),c3 varchar(10),c4 decimal(8,2),c5 datetime,c6 float,c7 money,c8 ntext,c9 nvarchar(max))
go
select name,system_type_id from sys.columns where object_id=object_id('tb')
/*
name system_type_id
-------------------------- --------------
c1 56
c2 175
c3 167
c4 106
c5 61
c6 62
c7 60
c8 99
c9 231
(9 行受影响)
*/
go
drop table tb
select * from syscolumns where object_id=object_id('表名')
--里面的name字段就是列名称
select * from sys.columns where object_id=object_id('表名')