SQL 查询修剪字符串

Question

我有一个查询如下

select 
    First_Name+' '+Middle_Name+' '+Last_Name as studentname,
    Batch,
    Batch+1 as batch1,
    Admtd_Semester,
    Program,
    Title,
    @His_Her as His_Her,
    Fathers_Name,
    Branch_Name,
    Student_Mobile_Number,
    Fathers_Mobilenumber,
    CONVERT(VARCHAR(10),GETDATE(),110) as date 
from 
    STUDENT_Admission_1212341

在上面的查询中，batch+1 给出的输出是 2014，我只需要 14。我该如何修剪它？

Answer 1

计算余数:

SELECT 2014 % 100

即:

SELECT  First_Name + ' ' + Middle_Name + ' ' + Last_Name AS studentname ,
        Batch ,
        (Batch + 1 ) % 100 AS batch1 ,
        Admtd_Semester ,
        Program ,
        Title ,
        @His_Her AS His_Her ,
        Fathers_Name ,
        Branch_Name ,
        Student_Mobile_Number ,
        Fathers_Mobilenumber ,
        CONVERT(VARCHAR(10), GETDATE(), 110) AS date
FROM    STUDENT_Admission_1212341