Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $host = 'SRV1';
- $db = 'FLOT_RRR';
- $user = 'coolman';
- $pass = '******';
- $charset = 'windows-1251';
- $dsn = "dblib:version=4.2;host=$host;dbname=$db;$charset";
- try {
- $pdo = new PDO($dsn, $user, $pass);
- } catch(PDOException $e) {
- die("Failed to get DB handle: " . $e->getMessage()) ;
- }
- $st = $pdo->prepare('EXEC dbo.getNumberSmallShips');
- $res = $st->execute();
- USE [FLOT_RRR]
- GO
- /****** Object: StoredProcedure [dbo].[getNumberSmallShips] Script Date:
- 04/25/2018 09:26:47 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER PROCEDURE [dbo].[getNumberSmallShips]
- AS
- BEGIN
- SET NOCOUNT ON;
- SELECT COUNT (*) FROM
- (SELECT FLO_RN,FLO_FKL FROM flotmintrans
- WHERE FLO_FKL LIKE '%мс%' OR
- FLO_FKL LIKE '%категория%' OR
- FLO_FKL LIKE '%категория 3%' OR
- FLO_FKL LIKE '%категория 4%' OR
- FLO_FKL LIKE '%категория 5%' OR
- FLO_FKL LIKE '1' OR
- FLO_FKL LIKE '2' OR
- FLO_FKL LIKE '3' OR
- FLO_FKL LIKE '5' OR
- FLO_FKL LIKE '4'
- AND FLO_DSU IS NULL) AS subqury
- END
Add Comment
Please, Sign In to add comment