SQl Query

Keyur try this below script,

IF OBJECT_ID('TEMPDB..#TEMP') IS NOT NULL
BEGIN
    SELECT 'TABLE EXISTS'
    DROP TABLE #TEMP
END

CREATE TABLE #TEMP
(
    ID INT IDENTITY(1,1)
    ,STRING VARCHAR(100)
)

INSERT INTO #TEMP VALUES ('?keyword=sweet'),('?keyword=sweet1'),('?type=326_338_389')

SELECT  RIGHT(SUBSTRING(STRING,1,CHARINDEX('=',STRING)-1),DATALENGTH(SUBSTRING(STRING,1,CHARINDEX('=',STRING)-1))-1) AS [Key]
       ,REPLACE(STRING,SUBSTRING(STRING,1,CHARINDEX('=',STRING)),'') as Value
FROM #TEMP