How to implement string interception in sqlserver

How to implement string interception in sqlserver? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

The code is as follows:

Parsename can return four values = Object name= Schema name= Database name= Server name

The 1 in select parsename (ip,1) from cs,2,3,4 refers to the number after the first decimal point, from right to left, in reverse order.

The code is as follows:

Elect parsename ('A recordB, C.C., Fleming, 2)-the syntax of parsename is to intercept points. The following string, 1 is the penultimate, 2 is the penultimate.

This is the answer to the question about how to intercept strings in sqlserver. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.