1:在SQL语句中,将存储过程结果集(表)存入到临时表中
insert into #tmp EXEC P_GET_AllChildrenComany '80047'
说明:#tmp要提前创建好
2:字符串循环分割处理
1:字符串分割循环 declare @str varchar(1000) declare @splitchar varchar(5) set @str='01,02,333,U04,5,' set @splitchar=',' declare @location int set @location=charindex(@splitchar,@str) while @location<>0 begin print substring(@str,1,@location-1) set @str=substring(@str,@location+1,len(@str)-@location) set @location=charindex(@splitchar,@str) end
3:字段累计拼接()
DECLARE @Salary VARCHAR(MAX) ='' SELECT @Salary = @Salary + '[' + SalaryItemID +'],' FROM Rlzy_MDB.dbo.U_SalaryItems SET @Salary=SUBSTRING(@Salary,1,LEN(@Salary)-1)
4:获取表结构信息
exec sp_help 'SD_001_FM03_RESULT'