Assuming begin is required, the following 35 results were found.
-
BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
string value ** Return Values : None *********************************************************************************/ BEGIN DECLARE @StringValue VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
user defined function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
user defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS but not -- mentioned in the above OUT variables: DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
** ** ** *****************************************************************************************************************/ BEGIN TRY BEGIN TRANSACTION A DECLARE @NumberLeft INT DECLARE @random INT DECLARE @CurrentID INT DECLARE @ScrambledID INT DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'");...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
set it to the maximum time (adds a lot of load) If you are using working hours boolean you could do: IF @DisplayHours = 1 BEGIN --First hour of the day SET @StartTime = @GivenDate + ' 08:00:00'; --Last hour of the day SET @EndTime = @GivenDate + '...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Example: My example accepts an Active Directory (AD)...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [stored_procedure_name ]; Example CREATE OR REPLACE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
** ** ** *****************************************************************************************************************/ BEGIN -- Declare some variables to use DECLARE @SqlToExecute nvarchar(max); DECLARE @FullSqlToExecute VARCHAR(max); DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
** ** ** *****************************************************************************************************************/ BEGIN -- Declare some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as these might answer your question to begin with and then we'll do the easy bit on how you set...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Pancakeshttp://mail.joellipman.com/articles/_other-misc/pancakes.html
high above the bowl so the flour gets a airing. Now make a well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were the instructions for applying the template...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
v5.0.45 Camtasia Studio v5.0 For Demonstration Purposes We want to add a video called "EXAMPLE.SWF" to an article Let's begin Create your video in Camtasia Studio and produce the SWF files Finish doing your video Go to File > Produce Video As... >...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
file. The text file should be a list of website addresses, each on their own line. The program will confirm that it will begin batch processing, (if more than 20 then it won't list them all), it processes them based on the options you set under "Tools >...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
functions for AHK) alert(), getElementById(), getElementsByName(), getElementsByTagName(), focus(), click() Before we begin, this tutorial will be using examples that start with javascript: - which you will feed through the URL Address bar. These...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF