... this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums:
BEGIN
DECLARE i INT DEFAULT 0; -- total number of delimiters
DECLARE ctr INT DEFAULT 0; -- counter for ...
Just putting a note as I have spent ages looking for a solution and getting it to work in my environment.
What?
Need to be able to omit HTML tags in certain fields of a mySQL database.
Why? ...
... below... hopefully it will be quicker next time now that I noted it all down.
The SQL Script:
DECLARE
@StartTime datetime,
@EndTime datetime,
@GivenDate datetime;
SET DATEFORMAT dmy;
SET ...
... -- II. 1. Declare some variables
-- -----------------------------------------------------------------------------
-- A bit obsolete as we'll address each variable per section.
-- NOTE: ...
... use Outlook for this...
The DataSet
The script I used to generate the dates comes from www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/
DECLAR ...
... bookings for a week based on a given date and campus
-- ===============================================================================
DECLARE
@GivenDate datetime,
@GivenCampus varchar(100),
@setId ...
The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...
... during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure.
The ...
... you try adding a comment, you may get something like the following:
Fatal error:
Cannot redeclare_recaptcha_qsencode() (
previously declared in /public_html/plugins/system/jezReCaptcha/recaptcha-php-1.10/recaptchalib.php:47
)
in ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.