Left join producing wrong result Where clause inside sub query hello 1D Hotel Suikwan tests Use the right tool to get identity values back after an insert A more controllable random string generator function for SQL Server Training1 pk Генерация чисел в диапазоне в MS SQL