CREATE PROCEDURE Pr_select_user_question
@sys_id char(10),
@ques_class int,
@top int,
@profession_id int
AS
begin
declare @sql nvarchar(500)
if @sys_id=' '
set @sql='select top ' + str(@top) + ' question.*,picture.picture from question left outer join picture on question.picture_id=picture.picture_id and profession_id=' + str(@profession_id) + ' and ques_class= ' + str(@ques_class) +' order by newid()' if @profession_id=0
set @sql='select top ' + ltrim(str(@top)) + ' question.*,picture.picture from question left outer join picture on question.picture_id=picture.picture_id and sys_id='''+ @sys_id + ''' and ques_class=' + str(@ques_class) + ' order by newid()'
exec(@sql)
end
GO
@sys_id char(10),
@ques_class int,
@top int,
@profession_id int
AS
begin
declare @sql nvarchar(500)
if @sys_id=' '
set @sql='select top ' + str(@top) + ' question.*,picture.picture from question left outer join picture on question.picture_id=picture.picture_id and profession_id=' + str(@profession_id) + ' and ques_class= ' + str(@ques_class) +' order by newid()' if @profession_id=0
set @sql='select top ' + ltrim(str(@top)) + ' question.*,picture.picture from question left outer join picture on question.picture_id=picture.picture_id and sys_id='''+ @sys_id + ''' and ques_class=' + str(@ques_class) + ' order by newid()'
exec(@sql)
end
GO
谢谢libin_ftsafe(子陌红尘)