What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-08 05:37:17
back up stored procedures mysql
# Stored Procedures Plus Everything mysqldump -R <dbname> #or mysqldump --routines <dbname> #Stored Procedures only mysqldump -n -t -d -R <dbname> #or mysqldump --no-create-db --no-create-info --no-data --routines <dbname> Add solution -
Other 2021-11-07 23:00:21
performance testing
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-10-29 20:41:14
medium generate-tsql-stored-procedures
CREATE proc [dbo].[USP_QuerycreationSupport](@table_Name varchar(100))asbeginDECLARE @InserCols NVARCHAR(MAX)DECLARE @Inserparam NVARCHAR(MAX)DECLARE @Insertquery NVARCHAR(MAX)DECLARE @Selectquery NVARCHAR(MAX)DECLARE @Update NVARCHAR(MAX)DECLARE @DeleteQ... Add solution -
Other 2021-10-20 04:30:08
what is performance testing
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 -
SQL 2021-10-19 04:55:12
sql interview questions
/* Answer to: "sql interview questions" */ /* Here are 50 common questions you may be asked in an interview! Go to https://www.guru99.com/sql-interview-questions-answers.html for the answers of each question. 1. What is DBMS? 2. Wh... Add solution -
Other 2021-10-14 16:07:04
cursors in db2
In Db2, an application program uses a cursor to point to one or more rows in a set of rows that are retrieved from a table. You can also use a cursor to retrieve rows from a result set that is returned by a stored procedure. Your application program can u... Add solution -
SQL 2021-09-18 06:04:04
sql interview questions for 5 years experience
/* Answer to: "sql interview questions" */ /* Here are 50 common questions you may be asked in an interview! Go to https://www.guru99.com/sql-interview-questions-answers.html for the answers of each question. 1. What is DBMS? 2. Wh... Add solution -
Other 2021-09-06 12:32:04
Explain the Stored Procedure
Stored Procedure : A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execu... Add solution