python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - dynamic-sql

Declare and return value for DELETE and INSERT

I am trying to remove duplicated data from some of our databases based upon unique id's. All deleted data should be stored in a separate table for auditing purposes. Since it concerns quite some datab...
test-img

Bobstar

postgresql

sql-insert

plpgsql

sql-delete

dynamic-sql

Votes: 0

Answers: 3

Latest Answer

You need to create and then call a plpgsql procedure with input parameters : CREATE OR REPLACE PROCEDURE duplicates_suppress (my_target_schema text, my_source_schema text, my_source_table text, unique...
test-img

Edouard

What is the merit of prepared statement in mysql

After I read about prepared statement,I can set prepared statement like following. It worked, but I haven't understood what is the merit of prepared statment. because I wonder what is the merit beyond...
test-img

Heisenberg

mysql

sql

dynamic-sql

Votes: 0

Answers: 0

Dynamix SQL Error "Must declare the scalar variable"

I have the @inAdd1-6 and @inAdd declared. The @inAdd1-6 will actually be passed into the Stored Procedure. I will then split them and process the addresses, some as a single address, and others where...
test-img

Dizzy49

sql

variables

dynamic-sql

variable-declaration

Votes: 0

Answers: 1

Latest Answer

You execute your generated statement with EXEC, so you call a new instance which is not aware of any declarations you made in your base script You have to add the declarations to your new script WHILE...
test-img

J.Starkl

SQL Server stored procedure parameters syntax error

I have the following query: DECLARE @periodEnd datetime = '2021-12-09 02:41:42.000' DECLARE @ID VARCHAR(50) = '35915D4B-E210-48C0-ADD5-C68AAEB62C36' EXEC('SELECT COUNT(*) AS count FROM pageloads nolo...
test-img

billi j

sql

sql-server

tsql

dynamic-sql

Votes: 0

Answers: 2

Latest Answer

There is no need for dynamic SQL here. The actual code you have won't generate that error either; it would likely generate this error instead: Msg 241, Level 16, State 1, Line 4 Conversion failed whe...
test-img

Thom A

Posts

Questions

Blogs

Jobs