Convert different Date format to the SQL Acceptable one.

Declare @DateTimeValue nvarchar(100)= '03/01/2017 13:15'


--Date Value
SELECT CONVERT(CHAR(10),CONVERT(DATETIME,LEFT(@DateTimeValue,10),105),101);

--Date Time Value
Select Cast(CONVERT(VARCHAR(24), CONVERT(DATETIME, max(@DateTimeValue), 103), 101)+' '+ CONVERT(VARCHAR(5), CONVERT(DATETIME, max(@DateTimeValue), 103), 108) as datetime)

SQL: Trimming all the column values using LTRIM and RTRIM dynamically

The below SQL Dynamic Query will remove all the white spaces from each column of datatype varchar or nvarchar using LTRIM and RTRIM.

DECLARE @SQL VARCHAR(MAX)
DECLARE @TableName NVARCHAR(128)
SET @TableName = 'Users'

SELECT @SQL = COALESCE(@SQL + ',[', '[') +
              COLUMN_NAME + ']=LTRIM(RTRIM([' + COLUMN_NAME + ']))'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @TableName
    AND (DATA_TYPE = 'varchar' OR DATA_TYPE = 'nvarchar')

SET @SQL = 'UPDATE [' + @TableName + '] SET ' + @SQL

PRINT @SQL
EXEC(@SQL)