Mysql procedure toturial

http://www.mysqltutorial.org/mysql-if-statement/

DELIMITER $$
 
CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    PROCEDURE `hps_mosir`.`test`(IN countryName VARCHAR(255), OUT total INT)
 
 
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN
 
 
	SELECT COUNT(*) INTO total FROM `banners` WHERE `name` = countryName;
 
    END$$
 
DELIMITER ;
CALL test('G1', @total);
SELECT @total;

Atrakcje turystyczne Słoweni

Atrakcje turystyczne

W Lublanie na uwagę zasługuje całe Stare Miasto, Pałac Biskupi, lublański zamek, park Tivoli, Muzeum Narodowe czy centrum kulturalne Metelkova. Słowenia to także górskie kurorty, Jaskinie Szkocjańskie oraz malownicze miejscowości, takie jak Skofja Leka. Dużą atrakcją są baseny termalne w Dolenjskich Toplicach oraz liczne zamki – Brezice, Bogensperk czy Podsreda.

Kategoria: 

Glimpse - Debug

Glimpse is a thriving and growing family of open source NuGet packages that provides detailed performance, debugging and diagnostic information for ASP.NET apps. It's trivial to install, lightweight, ultra-fast, and displays key performance metrics at the bottom of every page. It allows you to drill down into your app when you need to find out what's going on at the server. Glimpse provides so much valuable information we recommend you use it throughout your development cycle, including your Azure test environment. While Fiddler and the F-12 development tools provide a client side view, Glimpse provides a detailed view from the server. This tutorial will focus on using the Glimpse ASP.NET MVC and EF packages, but many other packages are available. Where possible I will link to the appropriate Glimpse docs which I help maintain. Glimpse is an open source project, you too can contribute to the source code and the docs.

http://www.asp.net/mvc/overview/performance/profile-and-debug-your-aspnet-mvc-app-with-glimpse

Kategoria: 

Strony

Subskrybuj Notatnik RSS