有关col_length('table','column')函数
create table a ( col1 varchar(4),
col2 nvarchar(4))
go
select col_length('a','col1') as vc,
col_length('a','col2') as nvc
结果是 vc nvc
4 8
但是
create table #a ( col1 varchar(4),
col2 nvarchar(4))
go
select col_length('#a','col1') as vc,
col_length('#a','col2') as nvc
结果却是
vc nvc
null null
哪位高手可以解决我心中的困惑。