Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 create a stored procedure and saving it on a database): IF OBJECT_ID('usp_CountRecordsPerTablePerColumn', 'P') IS NOT NULL DROP PROCEDURE [usp_CountRecordsPerTablePerColumn]; GO CREATE PROCEDURE [usp_CountRecordsPerTablePerColumn] ( @p_Value int,...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 large bowl, then stir in flour, baking soda and salt. Add chocolate chips and pecans. That's it. That's your dough. Step 3: Drop Drop globs of dough, by rounded tablespoons, onto an parchment paper-lined cookie sheet. Leave about 2 inches between...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO --...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 mysql user has been granted all privileges (change this after a successful install and remove system privileges such as "drop table"). Upload the compressed file to your http://www.mysite.com/ web root folder and extract the zip to it (it should create...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database. db_securityadmin Members of the db_securityadmin fixed database role can modify role membership and manage...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_MDIGETACTIVE = $0229 Const WM_MDISETMENU = $0230 Const WM_ENTERSIZEMOVE = $0231 Const WM_EXITSIZEMOVE = $0232 Const WM_DROPFILES = $0233 Const WM_MDIREFRESHMENU = $0234 Const WM_IME_SETCONTEXT = $0281 Const WM_IME_NOTIFY = $0282 Const WM_IME_CONTROL...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now how to...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy location. I found a quicker fix than...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( @p_SearchTable...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 database to SQL file. (Export > Custom > Save output to file) Except for configuration.php, delete all files in TEST folder. Drop all tables in TEST database. Copy all files from LIVE to TEST (Do not overwrite configuration.php !!!) Copy database from...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot drop database because it is currently in use Restoring a SQL Database Backup Using SQL Server Management Studio Unable to restore...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 my site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; //...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product Update"] JSON Payload [Multi Line] 2. Joel's first Cheat: If...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Testudine (Tortoise) Tigrine (Tiger) Ursine (Bear) Vespine (Wasp) Botanical Fernaceous (Fern) Lupine Rosaceous (Rose) Backdrops Beach Car Desert Factory Forest Horizon Lake Lawn London Mountains New York Paris Piscine (Swimming Pool) Rooftop Snow...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *