Guest User

Untitled

a guest
Apr 26th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. $host = 'SRV1';
  2. $db = 'FLOT_RRR';
  3. $user = 'coolman';
  4. $pass = '******';
  5. $charset = 'windows-1251';
  6. $dsn = "dblib:version=4.2;host=$host;dbname=$db;$charset";
  7. try {
  8. $pdo = new PDO($dsn, $user, $pass);
  9. } catch(PDOException $e) {
  10. die("Failed to get DB handle: " . $e->getMessage()) ;
  11. }
  12.  
  13. $st = $pdo->prepare('EXEC dbo.getNumberSmallShips');
  14. $res = $st->execute();
  15.  
  16. USE [FLOT_RRR]
  17. GO
  18. /****** Object: StoredProcedure [dbo].[getNumberSmallShips] Script Date:
  19. 04/25/2018 09:26:47 ******/
  20. SET ANSI_NULLS ON
  21. GO
  22. SET QUOTED_IDENTIFIER ON
  23. GO
  24.  
  25. ALTER PROCEDURE [dbo].[getNumberSmallShips]
  26. AS
  27. BEGIN
  28.  
  29. SET NOCOUNT ON;
  30.  
  31. SELECT COUNT (*) FROM
  32. (SELECT FLO_RN,FLO_FKL FROM flotmintrans
  33. WHERE FLO_FKL LIKE '%мс%' OR
  34. FLO_FKL LIKE '%категория%' OR
  35. FLO_FKL LIKE '%категория 3%' OR
  36. FLO_FKL LIKE '%категория 4%' OR
  37. FLO_FKL LIKE '%категория 5%' OR
  38. FLO_FKL LIKE '1' OR
  39. FLO_FKL LIKE '2' OR
  40. FLO_FKL LIKE '3' OR
  41. FLO_FKL LIKE '5' OR
  42. FLO_FKL LIKE '4'
  43.  
  44. AND FLO_DSU IS NULL) AS subqury
  45. END
Add Comment
Please, Sign In to add comment