How-to articles, tricks, and solutions about SQL-SERVER

Here is an example of how to connect to a SQL Server database using PDO and the SQL Server driver:

In SQL Server, you can convert a varchar value to an integer or decimal value using the CAST or CONVERT function.

To connect to a SQL Server database using JDBC, you will need to use the JDBC driver for SQL Server.

In PHP, you can use the sqlsrv_real_escape_string() function to escape strings in SQL Server.