select MemberName from dbo.C_MemberInfo where Id in (18,19)这样的语句我想换成存储过程create proc sp_membername
(
@names nvarchar(100)
)
as
begin
select MemberName from dbo.C_MemberInfo where Id in (@names)
endexec sp_membername '18,19'出错了:从数据类型 nvarchar 转换为 bigint 时出错。
我该怎么改呢?
(
@names nvarchar(100)
)
as
begin
select MemberName from dbo.C_MemberInfo where Id in (@names)
endexec sp_membername '18,19'出错了:从数据类型 nvarchar 转换为 bigint 时出错。
我该怎么改呢?
@names int = null
(
@names int=null
)
as
begin
select MemberName from dbo.C_MemberInfo where Id in (@names)
end
exec sp_membername '18,19'改成这样也不行
还是那个错误:从数据类型 varchar 转换为 int 时出错。
set @sql = 'select MemberName from dbo.C_MemberInfo where Id in ('+@name+')';
exec @sql
(
@names int=null,
@sql nvarchar(500)
)
as
beginset @sql ='select MemberName from dbo.C_MemberInfo where Id in ('+@names+')';end这个怎么调用
exec sp_membername '18,19' ?
(
@names varchar(max)
)
asbegin
declare @sql varchar(max)
set @sql = 'select * from dbo.CFG_Trunk_Ext where Id in ('+@names+')';
exec (@sql)
end
exec sp_membername11 '1,2'