34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE ras_AttLeaveRecordSelectUsersInSpanTime
@UidList nvarchar(4000)= '*',
AS
SET NOCOUNT ON;
EXEC('SELECT [NAME] FROM ([RIMS].[dbo].[ras_AttLeaveRecord] WHERE (UID in ('+@UidList+' ) ')
SET NOCOUNT OFF;
declare @str varchar(500),@aaa varchar(8000)
set @str='1,2,3'
set @aaa='select * from (select '''+REPLACE(@str,',',''' as str union all select ''')+''') a '
exec(@aaa)
/*
str
------
1
2
3
*/
CREATE PROCEDURE ras_AttLeaveRecordSelectUsersInSpanTime
UidList nvarchar(Max)= '*',
AS
SET NOCOUNT ON;
declare @sql varchar(2000)
set @sql='SELECT [NAME] FROM ([RIMS].[dbo].[ras_AttLeaveRecord] WHERE (UID in ('''+replace (@UidList,',',''',''') +''')'
exec (@sql)
go