What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-19 07:00:17
sp in sql server
Stored procedure A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the same query over and over again, you can save that specific query as a stored procedure and then just call by it's name. Basically wrapped thi... Add solution -
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 2022-01-30 15:41:01
delete stored proc sql server
DROP PROCEDURE <stored procedure name>; GO Add solution -
SQL 2022-01-22 22:26:23
set a value by excuting stored procedure
// Call to the stored procedure, with an OUTPUT parameter DECLARE @OutputParameter datetime ,@ReturnValue int EXEC @ReturnValue= [YourStoredProcedure] [comma separated parameters if any] @OutputParameter OUTPUT PRINT(@ReturnValue) Add solution -
Other 2022-01-22 06:21:50
performance testing test scenarios
1. Check if the page load time is within the acceptable range. 2. Check the page load on slow connections. 3. Check the response time for any action under a light, normal, moderate, and heavy load conditions. 4. Check the performance of database stored p... Add solution -
Other 2021-11-16 07:31:17
sqlite create stored procedure
SQLite no longer supports stored procedures! 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