需要有关SQL 2000存储过程的帮助

Andomar的回答是完全有效和非常优雅的-如果您想要更“脚踏实地”的东西,考虑到未来可能会有其他数值,请尝试以下方法:

CREATE PROCEDURE dbo.FetchImage(@ImageName VARCHAR(255))
AS
   IF EXISTS(SELECT * FROM dbo.ImageTable
             WHERE ImageName = @ImageName AND ImageSize = 3)
      SELECT
          Image
      FROM
          dbo.ImageTable
      WHERE
          ImageName = @ImageName AND ImageSize = 3
   ELSE
      SELECT
          Image
      FROM
          dbo.ImageTable
      WHERE
          ImageName = @ImageName AND ImageSize = 2

基本上是一样的-但它会继续返回 Image 对于 ImageSize = 3 即使你突然也有了4、5等大小的图像代码。

您可以通过简单的 top 1 :

create procedure dbo.GetImage(
    @ImageName varchar(50))
as
select  top 1 image
from    ImageTable
where   ImageName = @ImageName
order by
        ImageSize desc