Assuming drop is required, the following 23 results were found.
-
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: *
-
Typographyhttps://www.joellipman.com/articles/else/e-commerce/woocommerce/typography.html
which was created for the bliss of souls like mine. Bullets and Lists 100% Fully responsive Article Post Formats Drag and Drop Page Builder Extended Portfolio 100% Fully responsive Article Post Formats Drag and Drop Page Builder Extended Portfolio 100%...
- Type: Article
- Category: Uncategorised
- Language: *
-
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
-
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: *
-
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
-
- 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
-
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: *
-
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: *
-
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: *
-
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: *
-
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 Creator
- Language: *
-
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: *
-
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
-
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: *
-
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
-
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: *
-
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: *
-
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
-
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: *
-
$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