cs_user_avatar.prc

解压即可使用

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_User_Avatar]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_User_Avatar]
GO


CREATE procedure [dbo].cs_User_Avatar
(
	@UserID	int,
	@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
BEGIN
	IF EXISTS(SELECT UserID FROM cs_UserAvatar WHERE UserID = @UserID)
		SELECT
			U.UserID,
			U.ImageID,
			Length,
			ContentType,
			Content,
			DateLastUpdated
		FROM
			cs_Images I,
			cs_UserAvatar U
		WHERE
			I.ImageID = U.ImageID AND
			U.UserID = @UserID and I.SettingsID = @SettingsID and U.SettingsID = @SettingsID
END


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on [dbo].[cs_User_Avatar] to public
go