Question : I’m having 2 databases in 2 different servers(.246 and .252). I need to create backup for all stored […]
Tag: stored-procedures
How to return resultset from MySQL Stored Procedure using prepared statement?
Question : DELIMITER $$ CREATE PROCEDURE List_IL() BEGIN DECLARE Project_Number_val VARCHAR( 255 ); DECLARE Temp_List_val VARCHAR(255); DECLARE Project_List_val VARCHAR(255); DECLARE […]
Passing parameters in MySql procedure with prepare execute
Question : I am trying to write a procedure that has a location parameter, this parameter is later used in […]
Stored procedure execution time went from under 2mins to “infinity” without modifications
Question : I have an SSRS report that pulls it’s source from a vendor’s MSSQL 2012 database. It’s an extensive […]
SQL Server sometimes uses a lot more cpu for query
Question : I have a stored procedure with a quite heavy SELECT statement that includes five joins and uses FieldName […]
how to get multiple rows from multiple tables concatenated into a single string in a stored procedure in Oracle
Question : I have a table A that has 7 different 1-N relationships. Given an A id, now I am […]
Creating a table from variable names
Question : Is it possible to create a table from a variable name? For example I have the following stored […]
Is attaching a database on the same server under a different database name possible?
Question : I recently offered to help a friend with some development. She isn’t a technical person and it turned […]
Very slow SHOW PROCEDURE/FUNCTION STATUS WHERE Db = ‘a_database’
Question : I am experiencing a very unusual behaviour during nightly backups. The schema-only backup portion of the backup is […]
How can I improve performance of the stored procedure?
Question : Stored Procedure CREATE procedure [dbo].[ImproveProcedure] (@port varchar(50), @portdate datetime) as Declare @intdate datetime select @intdate = max(rate_date) from […]