请问如何快速删除左边的N排序号？

Question

比如：

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

Answer 1

在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

Answer 2

谢谢您的回答，请问有其他方法或者更简单的方法吗？