Issue I have been working on implementing a stored procedure to restore a database from a .bak file in an ASP.NET MVC application written in C#. However, when trying to execute the restore stored procedure, I get this error: RESTORE
Continue readingTag: stored-procedures
[SOLVED] Just out of interest, why cant you include paramters to an SP inside a WITH statement?
Issue I’m working on some VB.NET and need to kick off a SQL SP and if I put the following: Using connection As New SqlConnection(conString) Dim command As New SqlCommand("usp_EXT_101_<SPName>", connection) command.CommandType = CommandType.StoredProcedure command.CommandText = "Do something" Visual Studio
Continue reading[SOLVED] How to pass XML from C# to a stored procedure in SQL Server 2008?
Issue I want to pass xml document to sql server stored procedure such as this: CREATE PROCEDURE BookDetails_Insert (@xml xml) I want compare some field data with other table data and if it is matching that records has to inserted
Continue reading[SOLVED] How do i build a mysql stored procedure to join one out of two tables based on different conditions
Issue So let’s say i have three tables 1)User 2)Employee 3)Client user holds basic data of whether employee or client and has a column that mentions if that user is employee or client I want to achieve fetching the users
Continue reading[SOLVED] SQL – moving data from one table to another – referencing data
Issue I have a SQL table AccessLog, with following columns and sample data: | id | firstName | lastName | userEmail | loginTimestamp | | — | ——— | ——– | ———– | ———————— | | 1 | John |
Continue reading[SOLVED] Trigger vs procedure to update a calculated column
Issue I coded a trigger that calculated the value of a column (expiryDate) whenever the value of another column (productionDate) changed from null, and my professor told me I should have used a stored procedure: create or alter trigger tg_expiry_date
Continue reading[SOLVED] Search data from any column of the table from Oracle
Issue I want to implement one search logic here. What I want is, A user enters any text in the search box and presses enter. Then what should happen is, it should search in the table on any column and
Continue reading[SOLVED] How can i call json parameter In PostgreSQL Procedure
Issue Postgressql – 14 How can i call json parameter In PostgreSQL Stored Procedure when i do so i am getting thease error — Table CREATE TABLE tbl_user ( pk_user_id BIGSERIAL PRIMARY KEY, vhr_name VARCHAR(100) NOT NULL, vhr_password VARCHAR(500) NULL,
Continue reading[SOLVED] Javascript encodeURI like function in postgresql?
Issue Is there any function/stored procedure in PostgreSQL/plpgsql which is same as the javascripts encodeURI? What does it mean? Javascript have a handy built in function to encode any kind of url: encodeURI(url) -> returns the encoded url For example:
Continue reading[SOLVED] Dapper.NET and stored proc with multiple result sets
Issue Is there any way to use Dapper.NET with stored procs that return multiple result sets? In my case, the first result set is a single row with a single column; if it’s 0 then the call was successful, and
Continue reading