test_conn_sqlserver

conn.php

<?php

$conn = new PDO("dblib:version=8.0;charset=UTF-8;host=IPSERVIDOR;dbname=NOMBREDB", 'USUARIO', 'PASSWORD');

$id = rand(); 
  
$query = "INSERT INTO Emp VALUES(" . $id .", 'Smith " . $id . "', 'Carpintero', 2, 300)";

$conn->query($query)->execute();

$stmt = $conn->query("SELECT * FROM Emp");
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

var_dump($result);