-- --3.9.1节示例 --
--SQL编码规范样例 DECLARE @id int SET @id=5 IF(@id>3) --在大于3时才进行查询 BEGIN SELECT * FROM Person.Address a INNER JOIN Person.StateProvince sp ON sp.StateProvinceID = a.StateProvinceID WHERE a.City='Bothell' END