/*=======================================
对象名称:PR_USER_GETLISTBYUSERIDSTRING
功能描述:根据以“,”分隔的USER_ID获取用户
参数说明:
调用示例:
作 者:
创建时间:-11-10
修改人:
修改时间:
========================================*/
ALTER PROCEDURE PR_USER_GETLISTBYUSERIDSTRING
(
@USER_ID_STRING NVARCHAR(50)
)
AS
DECLARE @V_SQL NVARCHAR(2000) ;
BEGIN
SET @V_SQL = 'SELECT [USER_ID], USER_LOGIN_NAME FROM [USER] WHERE [USER_ID] IN (' + @USER_ID_STRING + ')';
EXECUTE SP_EXECUTESQL @V_SQL;
END;
GO
EXECUTE PR_USER_GETLISTBYUSERIDSTRING '24,25'
对象名称:PR_USER_GETLISTBYUSERIDSTRING
功能描述:根据以“,”分隔的USER_ID获取用户
参数说明:
调用示例:
作 者:
创建时间:-11-10
修改人:
修改时间:
========================================*/
ALTER PROCEDURE PR_USER_GETLISTBYUSERIDSTRING
(
@USER_ID_STRING NVARCHAR(50)
)
AS
DECLARE @V_SQL NVARCHAR(2000) ;
BEGIN
SET @V_SQL = 'SELECT [USER_ID], USER_LOGIN_NAME FROM [USER] WHERE [USER_ID] IN (' + @USER_ID_STRING + ')';
EXECUTE SP_EXECUTESQL @V_SQL;
END;
GO
EXECUTE PR_USER_GETLISTBYUSERIDSTRING '24,25'