Sql中怎一Table量值另一Table量
段SQL回出,有什方法可以代替呢?
declare @cUserRole varchar(210)
set @cUserRole= 'JiliangJin, '
declare @tempTable table(result Varchar(50))
set @tempTable = dbo.ufn_Splitter(@cUserRole, ', ')
(我不想用:
insert into @tempTable (result) select result from dbo.ufn_Splitter(@cUserRole, ', '),因回影效能
)
select * from @tempTable
[解决办法]
为什么会影响性能呢?