积极答复者
请问如何快速删除左边的N排序号?

问题
-
比如:
1 Create FUNCTION [dbo].[SplitToTable] 2 ( 3 @SplitString nvarchar(max), 4 @Separator nvarchar(10)=' ' 5 ) 6 RETURNS @SplitStringsTable TABLE 7 ( 8 [id] int identity(1,1), 9 [value] nvarchar(max) 10 ) 11 AS 12 BEGIN 13 DECLARE @CurrentIndex int; 14 DECLARE @NextIndex int; 15 DECLARE @ReturnText nvarchar(max); 16 SELECT @CurrentIndex=1; 17 WHILE(@CurrentIndex<=len(@SplitString)) 18 BEGIN 19 SELECT @NextIndex=charindex(@Separator,@SplitString,@CurrentIndex); 20 IF(@NextIndex=0 OR @NextIndex IS NULL) 21 SELECT @NextIndex=len(@SplitString)+1; 22 SELECT @ReturnText=substring(@SplitString,@CurrentIndex,@NextIndex-@CurrentIndex); 23 INSERT INTO @SplitStringsTable([value]) VALUES(@ReturnText); 24 SELECT @CurrentIndex=@NextIndex+1; 25 END 26 RETURN; 27 END
答案
-
在C++编辑器中按住ATL选择列之后删除。
The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP
全部回复
-
在C++编辑器中按住ATL选择列之后删除。
The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP