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
-
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: Shopify
- Language: *
-
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: *
-
** ** ** *****************************************************************************************************************/ 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: *
-
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
-
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: *
-
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: *
-
which populates as: 08:00, 08:30, 09:00, 09:30... 19:30, 20:00. // get rid of all picklist options clear Time_field; // begin populating options thisStartHour = thisServiceRecord.Opening_Time.toString("HH"); thisClosingHour =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"\", " ") } v_NewFile := SubStr(v_NewFile, 1, InStr(v_NewFile, ".",, -1)-1) v_DisplayName := A_LoopFileName ; if file names begin with exclamation mark (for saleslogix) if(InStr(v_NewFile, "!")>0) { v_NewFilePt1 := SubStr(v_NewFile, InStr(v_NewFile,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *