sql server 2012 create or alter procedure IF OBJECT_ID(‘spCallSomething’) IS NULL EXEC(‘CREATE PROCEDURE spCallSomething AS SET NOCOUNT ON;’) GO ALTER PROCEDURE spCallSomething … –instead of DROP/CREATE

sql multiple insert postgres INSERT INTO User (name, surname, “roomId”) // roomId is with quetes(“”) because it is case sensitive in this example VALUES (‘Joe’, ‘Travolta’, 1), (‘Jim’, ‘Carrey’, 2), (‘Shakira’, ‘whenever’, 3); // remember about semicolon(;) at the end postgresql insert multiple rows INSERT INTO table_name (column_list) VALUES (value_list_1), (value_list_2), … (value_list_n);

sql file in postgres with pgadmin 1. Open/select the database in PgAdmin4 2. In the top menu, Click Tools, Query Tool 3. Click the left most icon in Query Tool and drill down to find the .sql file you want. 4. Click Select 5. To run, Click the lightning icon (to the right of “No […]

SQL Developer store procedure insert json file to blob CopyINSERT INTO my_table (json_doc) VALUES (UTL_RAW.convert(UTL_RAW.cast_to_raw(‘{….}’), ‘AL32UTF8’, ‘WE8MSWIN1252’));

SQL DELETE VALUES FROM TABLE ALL DELETE FROM Customers WHERE CustomerName=’Alfreds Futterkiste’; SQL DELETE VALUES FROM TABLE ALL DELETE FROM table_name WHERE condition;