javascript 延伸date formatstring 寫法

 Date.prototype.addDays = function (days) {
            this.setDate(this.getDate() + parseInt(days));
            return this;
        };
        Date.prototype.yyyymmdd = function() {
            var yyyy = this.getFullYear().toString();
            var mm = (this.getMonth()+1).toString(); // getMonth() is zero-based
            var dd  = this.getDate().toString();
            return yyyy + (mm[1]?mm:"0"+mm[0]) + (dd[1]?dd:"0"+dd[0]); // padding
        };

mssql 利用patindex substring....等達到regular replace 出想要的內容

mssql 利用patindex substring....等達到regular  出想要的內容
CREATE  FUNCTION regularSubIndex(
@searchKey NVARCHAR(50), @inText NVARCHAR(1000)
 )
RETURNS INT
AS BEGIN
    DECLARE @position INT
    DECLARE @rIndex INT = 0
    DECLARE @patten VARCHAR(50) = '%'+@searchKey+'-[0-9]%'
    SET @inText = SUBSTRING(@inText,PATINDEX(@patten,@inText),LEN(@inText)-PATINDEX(@patten,@inText)+1);
    SET @position = CHARINDEX(',',@inText);

    IF (@position>0)
    BEGIN
        SET @inText = SUBSTRING(@inText,1,@position-1)
    END
    SET @inText = REPLACE(@inText,@searchKey+'-','')

    IF ISNUMERIC(@inText)=1
    BEGIN
        SET @rIndex = CONVERT(INT,@inText)
    END

    RETURN @rIndex
END