What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-03 09:03:35
create a quick temp table with stored procedure sql
/* First you need to create a table type. */ CREATE TYPE Names AS TABLE (Name VARCHAR(10)) ; GO /* Next, Create a procedure to receive data for the table-valued parameter, the table of names and select one item from the table*/ CREATE PROCEDURE Ch... Add solution -
SQL 2021-11-21 09:43:23
create stored procedure mysql
-- MySQL -- example DELIMITER $$ -- Changes delimiter to $$ so can use ; within the procedure CREATE PROCEDURE select_employees() BEGIN select * from employees limit 1000; -- Use the ; symbol within the procedure END$$ DELIMITER ; -- Resets the del... Add solution -
SQL 2021-11-14 10:43:17
Mysql table variables
CREATE PROCEDURE my_proc () BEGIN CREATE TEMPORARY TABLE TempTable (myid int, myfield varchar(100)); INSERT INTO TempTable SELECT tblid, tblfield FROM Table1; ... -- Temporary tables in MySQL only exist for the duration of the connection -- and only ... Add solution -
SQL 2021-11-10 19:59:23
cursor procedure with python mssql get result
#********************************************************************** # FILENAME : CallSPMultiResultSet.py # # DESCRIPTION : # Simple ODBC (pyodbc) example to SELECT data from two tables # via a stored procedure, returning... Add solution