摘要:
View Code 1 CREATE FUNCTION [dbo].[TransUserIdsToNames] ( @ids NVARCHAR(1024) ) --以;分隔的用户ID字符串 2 RETURNS VARCHAR(50) 3 AS 4 BEGIN 5 DECLARE @returns NVARCHAR(1024) 6 DECLARE @t TABLE ( id VARCHAR(10) ) 7 DECLARE @i INT 8 DECLARE @id NVARCHAR(10) 9 SET @... 阅读全文
摘要:
View Code 1 DECLARE @stime DATETIME 2 SET @stime = GetDate() 3 4 DECLARE @returnValue TABLE 5 ( 6 id INT , 7 parentId INT , 8 [path] VARCHAR(1000) , 9 lev INT10 )11 12 DECLARE @i INT13 SET @i = 014 15 INSERT INTO @returnValue16 SELECT ID ,17 ... 阅读全文