Replicate Function

DECLARE @i VARCHAR(800)

SELECT @i = REPLICATE('A', 116)

SELECT @i = 'CREATE TABLE #'+@i+'(i int)'

PRINT @i

EXEC(@i)

CREATE INDEX WITH MAXDOP OPTION

CREATE NONCLUSTERED INDEX IX_COLUMN_NAME ON DBO.T_TABLENAME

(COLUMN_NAME) WITH (ONLINE = OFF, MAXDOP = 1)

CHARINDEX - PATINDEX - USAGE

SELECT

REPLACE(SplitRange,' ',''),

REPLACE(Range_Start,' ',''),

REPLACE(Range_End,' ',''),

REPLACE([year],' ','')

FROM

(

SELECT

--SUBSTRING([expressions], CHARINDEX('>=',[expressions]),CHARINDEX('<',[expressions])-CHARINDEX('>=',[expressions])+ Len('<')) as col1,

--SUBSTRING(expressions, PATINDEX('=', replace(expressions,' ','')), PATINDEX('<',replace(expressions,' ',''))),

SUBSTRING(expressions,1,1) as SplitRange,

SUBSTRING(expressions, CHARINDEX('=', expressions) + 1, 6)as Range_Start,

case

when expressions like '%<%' Then SUBSTRING(expressions, CHARINDEX('<', expressions) + 1, 6)

else ''

end

as Range_End,

right(expressions,5) as [year]

FROM #t_expressions

)X

DataLength for Nvarchar Column Check

SELECT DATALENGTH([DATEUPLOADED]),[DATEUPLOADED]

FROM  [DBName].[dbo].[T_TableName] 

WHERE DATALENGTH([DATEUPLOADED]) <> 20

In the nvarchar column, one word refers to 2 bytes per character. Therefore, 10 words in date format refers to 20.