INSERT INTO Sales.Customer ([TerritoryID],[CustomerType]) VALUES (8,'S')

GO

SELECT SCOPE_IDENTITY()