SET 0 in left of string digits

 SELECT  RIGHT('000'+ISNULL(ID_String,''),4), * FROM ExcelData_K

ORDER BY ID

Excel Float Short Form value fixed

 =TEXT(C2,"00%") 

Now upload excel file to sql server. then remove last 3 characters. Use: =TEXT(C2,"00%")

Delete last 3 Characters in SQL

  DECLARE @String NVARCHAR(100)

    SET @String = '12354851'
    SELECT LEFT(@String, NULLIF(LEN(@String)-1,-1))

Get Invalid Date

 

Get Invalid Dates

function isdate().

Ammu with my sisters

 

Git Commands For check in Files. 3 Steps

 $ git add .  (git add . for all files changes/New)

$ git commit -m "Changes" (in Master branch changes)

$ git push (Finally push)

Get Only Firdays in SQL

 SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)

FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n

WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'