create table tb_1 ( id int, ch char(10) )godeclare @is_str char(20) declare @is_len int set @is_str ='12345467890123456789'select @is_len=length from syscolumns where object_id('tb_1') =id and name ='ch'insert tb_1(id,ch) select 2,left(@is_str,@is_len) select * from tb_1如用len或datalength取长度时,如表为空行,其取值将为NULL
--查询表栏位的类型和长度 select c.name '表名',a.name '栏位名',b.name '类型',a.length '长度' from syscolumns a inner join systypes b on a.xtype = b.xtype left join sysobjects c on a.id = c.id and c.xtype = 'U' where c.name = 'tablename'再根据"长度"用left函数来截取栏的值!
(
id int,
ch char(10)
)godeclare @is_str char(20)
declare @is_len int
set @is_str ='12345467890123456789'select @is_len=length from syscolumns where object_id('tb_1') =id and name ='ch'insert tb_1(id,ch)
select 2,left(@is_str,@is_len) select * from tb_1如用len或datalength取长度时,如表为空行,其取值将为NULL
select c.name '表名',a.name '栏位名',b.name '类型',a.length '长度' from syscolumns a
inner join systypes b on a.xtype = b.xtype
left join sysobjects c on a.id = c.id and c.xtype = 'U'
where c.name = 'tablename'再根据"长度"用left函数来截取栏的值!