34,590
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE get_paper_id
@course varchar(30),
@year int,
@semester varchar(8),
@paper_name varchar(100),
@id varchar(10) OUTPUT
AS
begin
declare @sql nvarchar(100)
set @sql='select @a = id from paper where 课程 = ''' + @course + ''' and 年份 = ''' + cast(@year as varchar) + ''' and 学期 = ''' + @semester + ''' and 试题 = ''' + @paper_name + ''''
exec sp_executesql @sql ,N'@a varchar(10) output' , @id output
end
ALTER PROCEDURE get_paper_id
@course varchar(30),
@year numeric(4,0),
@semester varchar(8),
@paper_name varchar(100)
AS
declare @sql nvarchar(100)
SET @sql=''
declare @id varchar(10)
SET @id=''
begin
set @sql='select @id=id from paper where 课程='''+@course+'''
and 年份='''+CAST(@year AS VARCHAR(4))+''' and 学期='''+@semester+''' and 试题='''+@paper_name+''''
exec sp_executesql @sql
end
RETURN @id
ALTER PROCEDURE get_paper_id
@course varchar(30),
@year numeric(4,0),
@semester varchar(8),
@paper_name varchar(100)
AS
declare @sql nvarchar(100)
declare @id varchar(10)
set @sql=''
set @id=''
begin
set @sql='select @id=id from paper where 课程='''+@course+'''
and 年份='''+@year+''' and 学期='''+@semester+''' and 试题='''+@paper_name+''''
exec sp_executesql @sql
end
RETURN @id