create table t(id int,a1 int,a2 varchar(10)) insert into t select 1,null,null godeclare @sql varchar(8000) set @sql='' select @sql=@sql+',isnull(cast('+name+' as varchar),''N/A'') as '+name from syscolumns where id=object_id('t') order by colid set @sql=stuff(@sql,1,1,'') exec('select '+@sql+' from t')drop table t--这个意思?
我想在存储过程中加日文,但输出总是乱码!请问如何解决?CASE WHEN @lang = 'en-US' THEN IsNull(EnglishName,'N/A') WHEN @lang = 'ja-JP' THEN IsNull(JapaneseName,'不明') END AS Name,
insert into t select 1,null,null
godeclare @sql varchar(8000)
set @sql=''
select @sql=@sql+',isnull(cast('+name+' as varchar),''N/A'') as '+name from syscolumns where id=object_id('t') order by colid
set @sql=stuff(@sql,1,1,'')
exec('select '+@sql+' from t')drop table t--这个意思?
WHEN @lang = 'en-US' THEN IsNull(EnglishName,'N/A')
WHEN @lang = 'ja-JP' THEN IsNull(JapaneseName,'不明')
END
AS Name,