Failed to load Msxmlsql.dll

Failed to load Msxmlsql.dll

  • Solution:
1
2
3
4
5
6
7
8
9
10
C:\Program Files\Microsoft SQL Server\100\Shared\msxmlsql.dll 
to
C:\Program Files\Microsoft SQL Server\MSSQL10_50.[veeam-dbinstance]\MSSQL\Binn

then copy "msxmlsql.rll" from
C:\Program Files\Microsoft SQL Server\100\Shared\Resources\1033\msxmlsql.rll
to
C:\Program Files\Microsoft SQL Server\MSSQL10_50.[veeam-dbinstance]\MSSQL\Binn\Resources\1033

Restart SQL Server Service

SQL PadLeft

SQL PadLeft

  • SQL
1
2
3
PRINT RIGHT(CAST(REPLICATE('0', LEN(no_start)) + CAST(no_start + (inventory - 1) AS VARCHAR(50)) AS VARCHAR(50)), LEN(no_start))

PRINT RIGHT(CAST(REPLICATE('0', LEN('000001')) + CAST('000001' + (50 - 1) AS VARCHAR(50)) AS VARCHAR(50)), LEN('000001'))
阅读更多

README

  • I Will Show You