在将 varchar 值转换成数据类型 int 时失败

2009-09-22 05:43:25 793 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

动态掩码语言模型(MLM)优化策略：效率提升与最新技术实践本文深入探讨了动态掩码语言模型(MLM)的优化策略与技术实践，涵盖核心原理、效率优化及2025年最新突破。重点解析了动态掩码在提升模型性能中的关键作用，包括工程实现、掩码策略演进及混合专家动态掩码等创新技术，为自然语言处理领域的研究与应用提供实用指南。阅读详情

create proc proc_kindName
(
@kind1 int,
@kind2 int,
@kind3 int,
@kind4 int,
@str varchar(500) output
)
as
if @kind1<>0
set @str=(select kindName from kind1 where auto_id=@kind1)+','
if @kind2<>0
set @str=@str+(select kindName from kind2 where auto_id=@kind2)+','
if @kind3<>0
set @str=@str+(select kindName from kind3 where auto_id=@kind3)+','
if @kind4<>0
set @str=@str+(select kindName from kind4 where auto_id=@kind4)
return ltrim(rtrim(@str))
go

declare @pp nvarchar(500);
exec proc_kindName 20,143,157,157,@pp output
select @pp

...全文

Sciter教程_00_创建HelloWorld工程本教程记录Sciter工程的创建和编译运行的过程。阅读详情

越过越咸

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

越过越咸 2009-09-25

打赏
举报

嗯谢谢各位的帮助已结贴

越过越咸 2009-09-25

打赏
举报

create proc proc_kindName
(
@kind1 int,
@kind2 int,
@kind3 int,
@kind4 int,
@str varchar(500) output
)
as
if @kind1 <>0
set @str=(select kindName from kind1 where auto_id=@kind1)+','
if @kind2 <>0
set @str=@str+(select kindName from kind2 where auto_id=@kind2)+','
if @kind3 <>0
set @str=@str+(select kindName from kind3 where auto_id=@kind3)+','
if @kind4 <>0
set @str=@str+(select kindName from kind4 where auto_id=@kind4)
return ltrim(rtrim(@str))
go

SQL77 2009-09-22

打赏
举报

create proc proc_kindName
(
@kind1 int,
@kind2 int,
@kind3 int,
@kind4 int,
@str varchar(500) output
)
as
if @kind1 <>0
set @str=(select kindName from kind1 where auto_id=@kind1)+','
if @kind2 <>0
set @str=@str+(select kindName from kind2 where auto_id=@kind2)+','
if @kind3 <>0
set @str=@str+(select kindName from kind3 where auto_id=@kind3)+','
if @kind4 <>0
set @str=@str+(select kindName from kind4 where auto_id=@kind4)

return

-->SELECT ltrim(rtrim(@str))
go

declare @pp nvarchar(500);
exec proc_kindName 20,143,157,157,@pp output
select @pp

贾桂权 2009-09-22

打赏
举报

create proc proc_kindName 

( 

@kind1 int, 

@kind2 int, 

@kind3 int, 

@kind4 int, 

@str varchar(500) output 

) 

as 

if @kind1 <>0 

  select @str=kindName+',' from kind1 where auto_id=@kind1 

if @kind2 <>0 

  select @str=@str+kindName+',' from kind2 where auto_id=@kind2 

if @kind3 <>0 

  select @str=@str+kindName+',' from kind3 where auto_id=@kind3 

if @kind4 <>0 

  select @str=@str+kindName from kind4 where auto_id=@kind4 

GO

lg314 2009-09-22

打赏
举报

return改成set或者弄成函数

7761098 2009-09-22

打赏
举报



create proc proc_kindName

(

@kind1 int,

@kind2 int,

@kind3 int,

@kind4 int,

@str varchar(500) output

)

as

if @kind1 <>0

set @str=’(select kindName from kind1 where auto_id=‘’‘’‘+@kind1+’‘’‘’),'

if @kind2 <>0

set @str=@str+‘(select kindName from kind2 where auto_id=’‘’‘’+@kind2‘‘’‘’),'

if @kind3 <>0

set @str=@str+’(select kindName from kind3 where auto_id=‘’‘’‘+@kind3+’‘’‘’),'

if @kind4 <>0

set @str=@str+‘(select kindName from kind4 where auto_id=‘’‘’’+@kind4+‘‘’‘’)’

return ltrim(rtrim(@str))

go



declare @pp nvarchar(500);

exec proc_kindName 20,143,157,157,@pp output

select @pp

贾桂权 2009-09-22

打赏
举报

create proc proc_kindName 

( 

@kind1 int, 

@kind2 int, 

@kind3 int, 

@kind4 int, 

@str varchar(500) output 

) 

as 

if @kind1 <>0 

select @str=kindName+',' from kind1 where auto_id=@kind1 

if @kind2 <>0 

select @str=@str+kindName+',' from kind2 where auto_id=@kind2 

if @kind3 <>0 

select @str=@str+kindName+',' from kind3 where auto_id=@kind3 

if @kind4 <>0 

set @str=@str+kindName from kind4 where auto_id=@kind4 

select ltrim(rtrim(@str)) 

go

xiequan2 2009-09-22

打赏
举报

[Quote=引用 2 楼 ycagri 的回复:]
只能return　int类型的

如果想返回字符类型，使用 output
[/Quote]..

ycagri 2009-09-22

打赏
举报

你把return去掉就可以了

ycagri 2009-09-22

打赏
举报

只能return　int类型的

如果想返回字符类型，使用 output

越过越咸 2009-09-22

打赏
举报

自己先顶在线等待...................

在将 varchar 值 转换成数据类型 int 时失败

相关推荐

在将 varchar 值转换成数据类型 int 时失败