34,587
社区成员
发帖
与我相关
我的任务
分享有关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
哪位高手可以解决我心中的困惑。
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
哪位高手可以解决我心中的困惑。
...全文
请发表友善的回复…
发表回复
j9988 2003-09-13
- 打赏
- 举报
create table #a ( col1 varchar(4),
col2 nvarchar(4))
go
select col_length('tempdb..#a','col1') as vc,
col_length('tempdb..#a','col2') as nvc
col2 nvarchar(4))
go
select col_length('tempdb..#a','col1') as vc,
col_length('tempdb..#a','col2') as nvc
